I need to track the number of points accumulated during the past 6 months. We use a point system to track attendance over the last 6 months. Tardys count as 0.5, then callouts count either as 1 or 1.5 points. NCNS counts as 5.
Column A is the Months and the top row is the days of the months. Here is as example:
Janurary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
February
March 0.5
April
May 1
June
July 1.5
August
September
October 1
November
December
January
I currently have to manually delete points that are older than 6 months. Is there a way I can assign each cell a date? This way I can have a formula that only counts dates present and back to 6 months.
Thank you for any ideas and assistance.
Bookmarks