Date compared to today

B

BethD

I have a worksheet with two columns (Appraisal Status and Appraisal Due Date.
Both columns are filled with data from a separate worksheet using the
VLOOKUP command. I have a thirdcolumn where I wish to put a YES if the
Appraisal status is NOT equal to "Completed" AND the date in the Appraisal
Due Date is less than todays date. ALl I can get is NO responses. for every
situation. Can you help?


A1 B1 C1
Completed need NO response
Registered 11/27/2008 need YES response
Registered 05/30/2009 need NO response

=IF(AND(A1<>"Completed",B1<TODAY()),"YES","NO")
 
A

Ashish Mathur

Hi,

The formula seems correct. IT looks like the entries in column B are non
dates. Please use the isnumber() formula on column B to check if the
entries there are dates or not.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
P

Pete_UK

If the entries in column B are text values, then you could amend your
formula like this:

=IF(AND(A1<>"Completed",--B1<TODAY(),B1<>""),"YES","NO")

Hope this helps.

Pete
 
B

BethD

This worked perfectly. Thank you. I'm not sure who everyone is that uses
help others in these discussion groups, but each time my "professor's afar"
have helped me out. Thank you again. Beth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the date of the previous Thanksgiving Day 11
Will Conditional Formatting work? 6
formulas to count dates 2
format number to date 7
text to date..! 3
how to count my paydays before the due-date of a bill? 11
extract name when a date in another cell gets near 5
Comparing two spreadsheets 2

Top