IF function using dates as cell references

E

Evelyn

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?
 
D

David Biddulph

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.
 
Top