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

[Guest]

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.

 

[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

 

[Guest]

Yahoo - that was exactly what I needed. Thank you KL!!