How do I name a range of dates?

R

Rick

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
 
B

Bob Phillips

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)
 
Top