View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jimo jimo is offline
external usenet poster
 
Posts: 2
Default calculating a pattern

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:)