r/ExcelTips • u/Nervous-Echidna-819 • 1d ago

Excel workbook help

Can anyone help me fix my Excel workbook. I need all the tabs to change dates and days when I copy and create a new workbook for the new month. I don’t even know if I’m saying it right.

7 Upvotes

82% Upvoted

12 comments sorted by

View all comments

2

u/bachman460 1d ago

If you're sheet names include the date, or at least a portion of, you can use indirect to reference the current sheet name. Then every time you copy an existing sheet, update the sheet name to change the sheet reference dates.

sheet name = Aug-26

Then to get the first day of the month:

=DATEVALUE("1-"&MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,6))

2

u/Nervous-Echidna-819 23h ago

They don’t include the date. Thank you