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.