MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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","")