• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.
  • Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automatically change tab using cell reference



Hope everyone was well.

I have a template file which has 5 tabs for each working day. I want to end up with each tab name having this format DAY DATE MONTH like MON 28 AUG using a date reference I input in a sheet.

Lets say in one worksheet I input the date 28/08/2023
The first tab (where this date reference is) I want it to be named Mon 28 AUG
and for the remaining days it then says:
Next tab Tue 29 AUG
Next tab Web 30 AUG
Next tab Thu 31 AUG
Next tab Fri 1 SEP

Is it possible to do this without macros?

Thanks in advance