how to use date in if fxn

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RAY - 10 Mar 2008 00:15 GMT

I would like to have my condition be a date in my true/false part of my IF
function. Is this possible?

Reply to this Message

Gary''s Student - 10 Mar 2008 00:20 GMT

=IF(TODAY()=DATE(2008,3,9),"yes","no")

Signature

Gary''s Student - gsnu200772

Reply to this Message

Tyro - 10 Mar 2008 01:42 GMT

=IF(1>2, DATE(2008,1,1),DATE(2007,2,1))

If 1 is greater than 2, the date of January 1, 2008 is returned. If 1 is not
greater 2 then the date of February 1, 2007 is returned..
Of course the cell containing the formula must be formatted as a date. If
not, you will see a date serial number.

Tyro

>I would like to have my condition be a date in my true/false part of my IF
> function. Is this possible?

Reply to this Message