let me apologize if this already posted but the forum kicked me out ....anyway...
I need a column to be have an IF statement that either says "yes" of "no" depending on a date so take the following example:
start date entitlement
jon 01-Jan-01
sam 15-Feb-08
jill 03-Oct-02
specific date 01-Oct-07
if the start date is greater (older) than the specific date then the entitlement should read "yes" if not then "no"
Thanks
Lushus
Try =if(startdatecell>specificdatecell,"Yes","No")
@Aileanor
Thakns but.....
is not working it gives me "no" for the first one then "yes" for the all the others, doesn't make sense
start date entitlement
jon 01-Jan-01 no
sam 15-Feb-08 yes
jill 03-Oct-02 yes
specific date 01-Oct-07
are you sure that all your dates are in fact dates (values) and not text?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@FDibbins
i right clicked the date column, went to format cells, made sure it was date ,,,still not working....am I doing something wrong?
Can you post an example?
formatting does not change the contents of the cell, all it does is change the appearance (cosmetics).
to check this, test a few cells using =isnumber(cell). True = a value, False = text
Hi Lushus,
We would love to continue to help you with your query, but first, before we can proceed, please see the forum rules about proper thread titles and adjust accordingly...
Please send me a PM when complete and this post will be removed…
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
Last edited by jeffreybrown; 09-22-2012 at 08:43 PM.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks