J
jimo
Using the following pattern:
DATE = ANSWER
---------- ------
12/16/2007 = 1A
12/17/2007 = 2A
12/18/2007 = 3A
12/19/2007 = 1B
12/20/2007 = 2B
12/21/2007 = 3B
12/22/2007 = 1A
12/23/2007 = 2A
12/24/2007 = 3A
12/25/2007 = 1B
12/26/2007 = 2B
12/27/2007 = 3B
12/28/2007 = 1A
12/29/2007 = 2A
12/30/2007 = 3A
how can I calculate the "ANSWER" when "DATE" = January 27, 2008?
DATE = ANSWER
---------- ------
1/27/2008 = ?
or any other date for that matter?
Thank you.
Jim O
DATE = ANSWER
---------- ------
12/16/2007 = 1A
12/17/2007 = 2A
12/18/2007 = 3A
12/19/2007 = 1B
12/20/2007 = 2B
12/21/2007 = 3B
12/22/2007 = 1A
12/23/2007 = 2A
12/24/2007 = 3A
12/25/2007 = 1B
12/26/2007 = 2B
12/27/2007 = 3B
12/28/2007 = 1A
12/29/2007 = 2A
12/30/2007 = 3A
how can I calculate the "ANSWER" when "DATE" = January 27, 2008?
DATE = ANSWER
---------- ------
1/27/2008 = ?
or any other date for that matter?
Thank you.
Jim O