how to use date in if fxn

R

RAY

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

Tyro

=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
 
Top