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.
Bookmarks