How do I name a range of dates?
Is the range of dates every date between those tow? If so, just use
=IF(ISNUMBER(MATCH(TODAY(),mydates,0)),"Period 1","")
If you just have the two dates, test them
=IF(AND(TODAY()=A1,TODAY()<=A2),"Period 1","")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Rick" wrote in message
...
How do I name a range of dates and then use that in a conditional formula.
For example:
If Today's date falls between 12/30/05 through 2/10/06, Today is in Period
1.
Thanks
|