Thread: IF function using dates as cell references
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 618
Default IF function using dates as cell references
Yes, providing that the dates have been entered as dates, not as text.

=IF(A1<A2,"Before","After") will work, but of course Excel won't understand
9/31/05 as a date.
--
David Biddulph

"Evelyn" wrote in message
...
I need a formula that will compare the dates in two cells and IF one date
is
before the other, THEN . . . . Can Excel read a date of 12/31/05 and
compare
it to 1/15/06, 9/31/05, etc to give me a result?


Reply With QuoteReply With Quote