Hi

Another solution
=MATCH(B8,{38322;38329;38336;38343;38350},1)
(returns #N/A when the date is less than 12/01/04 and 5 when the date is
past 12/28/04)
or
=MATCH(B8,{0;38322;38329;38336;38343;38350},1)-1
(which returns 0 when the date is less than 12/01/04 and 5 when the date is
past 12/28/04)


Arvi Laanemets


"Steve" wrote in message
...
if cell B8 has a date entered between the dates 12/01/04 and 12/07/04 I
would like a value of 1 entered in cell A8.
if cell B8 has a date entered between the dates 12/08/04 and 12/14/04 I
would like a value of 2 entered in cell A8.
if cell B8 has a date entered between the dates 12/15/04 and 12/21/04 I
would like a value of 3 entered in cell A8.
if cell B8 has a date entered between the dates 12/22/04 and 12/28/04 I
would like a value of 4 entered in cell A8.
Can anyone help?

Thanks in advance for your time,
Steve