Hello, I've been tasked with creating a new excel spreadsheet for 2021. I have previous years sheets. I need the new 2021 sheet to add daily count totals and then have them add up the weekly totals, then at the end of the year add all daily totals. I "think" I've copied the sheet including formulas to a new 2021 sheet. Now wondering if there is a way to change the dates in the date column to match the actual dates for 2021 instead of manually typing each day?
| Date | Tech | App Date | Total Records Checked |
| 01/01/2020 | | HOLIDAY | |
| 01/02/2020 | Don | 12/27/2019 | 500 |
| 01/03/2020 | Ruth | 12/30/2019 | 500 |
| WKLY TOTAL | | | 1000 |
