View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMJ JMJ is offline
external usenet poster
 
Posts: 11
Default Shift to the right depending on dates

I have about 300 columns of data.
I have a table with one column with data that needs to be placed somewhere
in those 300 columns depending on the starting date.
What formula should I place in the cells of those 300 columns to tell it to
begin placing values starting on that specific date?
Example:
Starting date: June 08
F G H I
J ....
May 08 June 08 July 08 Aug08 Sept 08 ......
300 columns


B
1. 35
2. 55
3. 57
6. 78
......
75. 155


Thanks for your help.