Hopefully, I can better explain what I'm looking to do. The spreadsheet is used to capture a lot of data. We are a manufacturing company, and we track chemical production records. The data is entered into the "2021" tab. The remaining tabs are used for metrics. For example, on the MFG BR Metrics and Charts tab, there is a table titled "Total Initiated by Month by Product Family". This just tells me how many production records for that product was issued for each month. The formula I use to capture the data is the COUNTIFS formula. This is the formula for January 2021:
February would be the same formula, but the > and < numbers would reflect January 31, 2021 and March 1, 2021, respectively, and so on for each month.
Each year, I have to create a new spreadsheet for the following year. As you can see from the formula, I'm asking for all "Chemical" records in Column A, where Column B (from the 20201 tab) is greater than 44196 (December 31, 2020) and less than 44228 (February 1, 2020) for all Buffer products. I do the same for every month, just changing out the numbers for each month's dates.
Currently, when I prepare the spreadsheet for the next year, I have to change all the dates (I can do this easily by find and replace throughout). However, I would like to know if there is a way to just have it capture the data for the month...."give me all the data for January, give me all data for February, etc." rather than telling it greater than December 31st but less than February 1st. This will allow me to just change the year, as well as accommodate leap years.