Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for calculating 12 month rolling period
I'm trying to link two absence spreadsheets together, each worksheet being a
separate month. I need a formula to calculate the absences on a rolling 12 month period, therefore, each time I input the current month's figures, it adds them to the 12 month rolling total but takes one month off the beginning of the 12 month period! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula will get a cell to update when the month changes | Excel Worksheet Functions | |||
Current date formula based on month | Excel Discussion (Misc queries) | |||
rolling 12 month average | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Date formula | Excel Discussion (Misc queries) |