| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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:) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pattern Matching | Excel Discussion (Misc queries) | |||
| Get rid of pattern | Excel Discussion (Misc queries) | |||
| how do i add a pattern to cells | Excel Discussion (Misc queries) | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| weekday pattern | Excel Discussion (Misc queries) | |||
Threaded Mode
