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

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)

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

=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

--
Regards,

Peo Sjoblom


"Thea" wrote in message
...
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)