On Sun, 9 Jan 2005 08:49:02 -0800, "Steve"
wrote:
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
|