Rolling Formula based on If
I have a graph that uses formula's gathering information from different
worksheets and other workbooks. The 'x' axis label inputs dates based on the
current formula which reads a specific set of cells from another sheet.
These dates currently are set and show an entire 12 month period or year on
each worksheet. (this can be changed)
My question: Is there a way to create a formula that will roll
automatically showing the previous 12 months of information from today's date.
example: If today is March 15, 2007, I want the graph to show March 15,
2007 thru March 15, 2006 of the previous year's input.
|