Apologies. I misread your message. Didn't see range of days.
Luckily David was more awake than I, and gave you the correct solution.

--
Regards

Roger Govier


"RS" wrote in message
...
I think you misunderstood my question. I want the text to be displayed
from
January 2nd through January 7th. Changing what you tell me will only
display
my message on January 7.

"Roger Govier" wrote:

Hi

Just change the "0102" to "0107" in your formula.
It would then say New when the date in H1 was 07 Jan

--
Regards

Roger Govier


"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.