Editing template calendar from 2025 to 2026

Dear @Ray Lasorsa,

Thank you for reaching out to the Microsoft Q&A Community. 

The best way to do this for all tabs is to group the sheets. This allows you to make a change on one sheet, and it will automatically apply to all the others.

1. Click on the first monthly tab (e.g., "January").
2. Hold down the Shift key on your keyboard.
3. Click on the last monthly tab (e.g., "December"). All the monthly tabs should now be highlighted and grouped.
4. In the active sheet, find the cell containing the formula =IF(MONTH(TODAY())=12,YEAR(TODAY())+1,YEAR(TODAY())) . This is typically a single cell at the top of the sheet that displays the year.
5. With that cell selected, delete the entire formula and simply type in 2026.
6. Press Enter.

Because the tabs were grouped, this change will be automatically applied to the same cell on every single monthly tab. To ungroup the sheets, simply click on any tab that is not highlighted. You can repeat this process for any year you want in the future. Should you have any further questions or need additional assistance, please don't hesitate to reach out. We're always here to help. Have a wonderful day!

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Dear @Ray Lasorsa,

It has been a while and I am writing to see how things are going with this issue. Have you had a chance to check the reply provided? If there’s anything else I can assist you with or if you need further clarification, please don’t hesitate to let me know, I’m here to help. Looking forward to hearing from you. Wishing you a great day ahead!

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Dear @Ray Lasorsa,

I hope you are having a great day so far.

I'm reaching out again to follow up on your issue and check if everything has been resolved. My goal is to ensure your experience remains smooth and hassle-free. If you're still encountering any problems or have run into new challenges, please let me know which steps you're currently stuck on and happy to provide further help whenever you need it. 

If you have any further questions, feel free to tag me in your reply so I can assist you directly.

Looking forward to your update.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.