Date compared to today

  • Thread starter Thread starter BethD
  • Start date Start date
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")
 
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
 
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
 
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
 
Back
Top