I am using a formula to calculate a rolling 90 days:
=SUMPRODUCT(--($A$5:$A$9647<=TODAY()),--($A$5:$A$9647>TODAY()-90),$F$5:$F$9647)
I need something similar but it will only calculate the first 90 days. Basically one cell will have a start date of something like 01/01/2009 and it will use that date as a starting date.
The thing is the rolling 90 days should not start calculating until after first 90 days is up. The cashier variances for the first 90 days will not be added into the beginning of the rolling 90 days.
Attached is a excel sheet that I am working with.
This is a very tough one, I really do appreciate any help.
Thanks,
Nick
Bookmarks