IF function using dates

Topic

New Reply

XL97 SR2.

Is it possible to get IF functions to work properly with dates? Eg, with a date formatted as 02/02/97 in cell A1,

=IF(A1>06/06/97,”Later”,”Earlier”).

I have tried putting the 06/06/97 as shown, in brackets, and in inverted commas but none of them work.

Reply | Quote

Replies

You could use the following formula :

=IF(A1>DATEVALUE(“06/06/97″),”Later”,”Earlier”)

Or you could put 06/06/97 in a seperate cell (say B1) and =IF(A1>B1,”Later”,”Earlier”)

Andrew C

Reply | Quote

Thanks Andrew

Reply | Quote