How do I name a range of dates?
 

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

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