EXCEL 2000 WIN 98 - IF Statements using dates.

Posted by Tony Douglas on January 25, 2002 5:59 PM

I need to know how to use a specific date within an IF statement. Such As

IF (DATE) = ( ??? ), then ( )-( ) otherwise, ""

Very simple but don't know how to install the date arguement.

Help!!! Thank you very much. Can't find in Excel Help.

Posted by Rob P. on January 25, 2002 7:37 PM

Have you tried the following?
=+IF(DATE(2001,11,30)=D5,"Y","N")
where D5 is November 30, 2001, the result is Y.