Is it an If statement?

[Steve]

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

 

[tjtjjtjt]

You could do this with IF, but you're better off with VLOOKUP. For more
information:
http://www.contextures.com/xlFunctions02.html

tj

 

[Aladin Akyurek]

=LOOKUP(B8,{0;38322;38329;38336;38343;38350},{"";1;2;3;4;""})

 

[Ron Rosenfeld]

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

You don't specify what you want to happen if the date in B8 is not within the
stated range.

Assuming you are using some method (data validation?) to assure the value is
within the stated range, then another method:

B8: =INT((B8-4)/7)-5473

If you require specifics for validating the entry, post back.


--ron

 

[Arvi Laanemets]

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