• 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