if statement, dependant on date

Posted by cj on March 31, 2001 12:42 PM

I'd like the words "end of month"
to be visible in cell A1 when the date is
between the 28th and the 29th of the month. Otherwise
the cell should be blank.

Regards

Posted by mseyf on March 31, 2001 1:35 PM

cj-

try:

=IF(OR(DAY(NOW())=28,DAY(NOW())=29),"End of Month","")

HTH

Mark

Posted by Aladin Akyurek on March 31, 2001 1:54 PM

Mark - You can shorten it a bit:

=IF(OR(DAY(NOW())={28,29}),"End of Month","")