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")
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")