Solved Date comparsion in excel

August 29, 2012 at 05:50:37
Specs: Windows XP
Hi All

I have 2 columns of date where i need to compare the date and if it matchs or less than that date i should give the answer as MET if not it should be NOT MET

EX: Target date=03/08/2012 and sent for reviwe=03/07/2012 here if target date met with sent review date the answer should be MET if it exceeds the targt date it should be NOT MET

This is in excel

Please Help Me

See More: Date comparsion in excel

Report •

August 29, 2012 at 06:03:28
✔ Best Answer
If your data looks like:

         A             B         C
1)  Target Date   Review Date   
2)    3/8/2012     3/7/2012     Met
3)    3/8/2012     3/9/2012     Not Met

In cell C2 enter the formula:

=IF(B2<=A2,"Met","Not Met")

Drag down as many rows as needed.


Report •
Related Solutions

Ask Question