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

[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.

[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


"gsmith" <[email protected]> wrote in message
news:[email protected]...
> 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.

[gsmith]

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

"KL" wrote:

> 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
>
>
> "gsmith" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>