How can I use a date in an IF/AND statement?

G

gsmith

Trying to formulate =IF(c2 > 01/31/05, 1,"2") Is there a different date
format to use?

Thank you in advance for any help.
 
K

KL

Hi,

Try this:

=2-(C2>VALUE("01/31/05"))

or

=2-(C2>DATEVALUE("01/31/05"))

or

=2-(C2>DATE(2005,1,31))

or

=IF(C2>DATE(2005,1,31),1,2)

etc.

Regards,
KL
 
Top