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
Bookmarks