Forum Discussion
Changing year on Excel
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 chang...
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?
Thanks - I have it sorted.