I found the below thread and was able to use the attendance tracker there, but I can't get it to calculate the points/occurrences on a rolling calendar year. I need it to track the number of UA, LA, ED at a rate of 1, .5, .5 per occurrence of each indicator, but I need it to only calculate for the date the calendar is being reviewed back 1 year. This is where I am having an issue I can't figure out how to get the tracker to calculate the rolling calendar and apply the point value to each code. UA =1, LA =.5, ED =.5
I would prefer not to have the Sheet 1 is possible and have the calculations happen on the Rolling Occurrence Summary Tab.
https://www.excelforum.com/excel-gen...ling-year.html
Bookmarks