ExcelBanter - IF function using dates as cell references

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF function using dates as cell references (https://www.excelbanter.com/excel-worksheet-functions/118919-if-function-using-dates-cell-references.html)

Evelyn

IF function using dates as cell references

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?

David Biddulph

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?

All times are GMT +1. The time now is 02:15 PM.