Hi,
Try this:
=2-(C2VALUE("01/31/05"))
or
=2-(C2DATEVALUE("01/31/05"))
or
=2-(C2DATE(2005,1,31))
or
=IF(C2DATE(2005,1,31),1,2)
etc.
Regards,
KL
"gsmith" wrote in message
...
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.
|