Track tardiness

Welcome to the Forum Vicki T!

Remove people's names and attach your file. The yellow banner at the top of the page explains how.

Ok hope I did it right. We give 1/2 pt for tardy's and leave early's and 1 pt for absent, 4 pts for no show/no call. I remove them 12 months from the date they received them. But I've been doing that part manually. There's got to be a better way.

I am going to respond here as this is the original thread and the file is posted here. (Please see Forum Rule #5 about thread duplication.)
If I understand correctly then I suggest the following:
1. Put actual date in row 3. This can be accomplished by putting 12/31/18 in cell BA3, 1/31/19 in cell BB3, selecting both cells and then dragging the fill handle to the right. Apply custom formatting mmm y.
2. Remove the Employee Totals column from the end of each year and place it in either column A or B so that it will not scroll along with the rest of the spreadsheet.
3. Populate the new Employee Totals column using: =SUMIFS(BB4:BZ4,BB$3:BZ$3,">="&EDATE(A$1,-12))
Note that I assume the months for 2021 will be inserted between Dec 20 and the Emergency Days Used columns.
Note that cell A1 is populated using: =EOMONTH(TODAY(),-1)
Let us know if you have any questions.

You're Welcome and thank you for the feedback. If the proposal resolves the issue please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.