Date in a cell is before or after a date in another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to compare the date in two cells. The format is mm/dd/yyyy. How
do I have to change the formula below to make the comparison work?

=IF(C1<8/1/2007,F1,0)
 
=IF(C1<--"2007-08-01",F1,0)

or

=IF(C1<DATE(2007,8,1),F1,0)


assuming you meant August 1st and not January 8th
 
Back
Top