I need a 12 month rolling number.
I need it to calculate a 12 period from the current date on the summary tab.
It can either go by the 12 months on the summary tab or by the 2012 and 2013 tabs and go by days.Attendance.xlsx
so if bob gets 2 points in January and 1 in july. Next January those 2 points will fall off and then he will be down to 1 point until july.
Here is a sample
Thanks
Bookmarks