| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=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 |
|
#3
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing dates in an IF function | Excel Worksheet Functions | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| if function with dates | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Linear Mode
