Displaying text during a range of dates
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.
|