View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BUD1888 BUD1888 is offline
external usenet poster
 
Posts: 8
Default Period of Performance calculations

I have a spreadsheet with a wide assortment of data. I have a period of
performance with start and end dates. What I want to do is to take those
dates and have a formula that will spread the necessary data across a period
of time that matches the POP.

Example:
POP Start 01/01/2008(B2) End 12/31/2014(C2)
Data: B6:B15
Years 2007 (C20); 2008 (D20); 2009 (E20); etc.

Any help would be great.

Bud1888