90 day Running total
 

I have a workbook set-up that contains two worksheets. One work sheet has the
current date and totals for individual inventory. The second worksheet has
the individual months with that months inventory. How do I set a formula in
the first sheet that will calculate the running total for the last 90 days
and automatically generate new totals when the date is changed on workeet 1?

90 day Running total
 

Excel 2007 PivotTable
Running totals for last 3 months.
With macro.
http://c0444202.cdn.cloudfiles.racks.../01_20_10.xlsm