Thread: Date in a cell is before or after a date in another cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
thea thea is offline
external usenet poster
  
Posts: 7
Default 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)
Reply With QuoteReply With Quote