IF function using a dates as the qualifier..

Guest · Jan 19, 2005

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

Thanks

N Harkawat · Jan 19, 2005

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

N Harkawat

Guest · Jan 19, 2005

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

Regards,

Peo Sjoblom

Count IF Function	7	Mar 5, 2008
Formula for converting xx/xx/xxxx dates to a number between 1 and	2	Aug 20, 2009
If Formulas	1	Oct 22, 2003
Excel if Functions	1	May 13, 2008
Assign each week number to corresponding month of the year	5	Sep 29, 2010
Formula IF	1	Feb 27, 2014
Multiple value if function using dates	2	Aug 27, 2009
how do I use if formula using dates?	4	Nov 7, 2005

Ask a Question