Auto sheet date change

Closed
Gouws Posts 45 Registration date Sunday February 7, 2010 Status Member Last seen April 15, 2012 - Jun 21, 2010 at 07:02 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2012 at 03:05 PM
Hello,
I got 31 spreadsheets one for each day of the month named 1Jun10-30Jun10.Is there a way of changing these dates automatically to say 1Jul10-31Jul10 by changing only the first date. OR is there a formula??


Related:

2 responses

sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Jun 21, 2010 at 10:15 AM
go to this link, think it's what you are looking for
https://www.mrexcel.com/archive/vba/auto-naming-sheet/
0
I got 31 spreadsheets one for each day of the month named 1Jun10-30Jun10.Is there a way of changing these dates automatically to say 1Jul10-31Jul10 by changing only the first date. OR is there a formula...
Iam not getting any answers for the above question.... pls hepl....
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 24, 2012 at 03:05 PM
0