Thread: Date in a cell is before or after a date in another cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default 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)


Reply With QuoteReply With Quote