Thread: how to use date in if fxn
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
  
Posts: 1,091
Default how to use date in if fxn
=IF(12, 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

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


Reply With QuoteReply With Quote