Hello all,
I have a spreadsheet that is used for users weekly stats. The sheet names have to be manually changed every week to this format:
Mm-dd-yyyy
Id like to be able to change cell A1 on the first sheet and have A1 on the other sheets to be the next days date. I then want the sheet names to reflect the date in A1 of each sheet. I know how to do the first part but can't figure out the sheet naming part.
Ive messed around with macros and VB code but the dates in A1 need to be in text format and I can't increment the date on the next sheet when its in text format.
Thanks!
Bookmarks