View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stroodle Stroodle is offline
external usenet poster
 
Posts: 1
Default 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!