Changing year on Excel

[Sandrap1104]

I am fairly new to excel and I have an existing excel annual leave/sickness tracker calendar for a previous year (which was used elsewhere).  I want to use the same workbook for 2022.  How do I change the calendar to reflect the correct year so that it will change the days of the month - at the moment when I change the year in the cell, it does not update to the correct year/month dates.

[#2]

@Sandrap1104 That depends on how the days are entered. If just by typing numbers and names of the days/months, there's not much you can do other than re-typing everything. Otherwise re-build the file and use real dates and some of Excel's date functions. Can you upload a screenshot showing how the file looks like and what's in the cells that contain the days/months?

[#3]

Thanks - I have it sorted.