Displaying text during a range of dates
=IF(AND(TEXT($H$1,"MMDD")="0102",TEXT($H1,"MMDD") <="0107"),"New","")
--
David Biddulph
"RS" wrote in message
...
Happy New Year everyone! I currently have formulas that display different
formatted text in cells when certain months & days occur (regardless of
the
year). I would like to modify one of the formulas such that I could
display
a text message over a range of consecutive days. Here is my current
formula
[where H1 displays todays date (1/2/07 for example):
=IF(TEXT($H$1,"MMDD")="0102","New","")
How would I modify this such that I could display this message from, let's
say 0102 to 0107? I'm using Excel 2003 & 2000.
|