ExcelBanter - IF function using a dates as the qualifier..

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF function using a dates as the qualifier.. (https://www.excelbanter.com/excel-worksheet-functions/9492-if-function-using-dates-qualifier.html)

Qaspec

IF function using a dates as the qualifier..

How do I write in a fomrula If (Jan 31st 2005 is greater than Today then
(-----) otherwise (------))

Thanks

N Harkawat

=if(date(2005,1,31)today(),(---),(---))

N Harkawat

"Qaspec" wrote in message
...
How do I write in a fomrula If (Jan 31st 2005 is greater than Today then
(-----) otherwise (------))

Thanks

Peo Sjoblom

=IF(DATE(2005,1,31)TODAY(),"Do This","DoThat")

Regards,

Peo Sjoblom

"Qaspec" wrote:

How do I write in a fomrula If (Jan 31st 2005 is greater than Today then
(-----) otherwise (------))

Thanks

All times are GMT +1. The time now is 01:26 AM.