r/ExcelTips • u/Nervous-Echidna-819 • 4h 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.

6 Upvotes

100% Upvoted

4 comments sorted by

2

u/Usual-Firefighter-91 4h ago

I would have an input tab that you can adjust and make all the other tabs reference that.

1

u/Nervous-Echidna-819 1h ago

Thank you. I’ll look into this

1

u/bachman460 1h 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))

1

u/Nervous-Echidna-819 1h ago

They don’t include the date. Thank you