Previous Topic Next Topic

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

Answer 1 / 2
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/
Answer 2 / 2
Pra
Mar 21, 2012 at 04:28 AM
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....
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 24, 2012 at 03:05 PM
why this link does not help you ?
https://ccm.net/forum/affich-402551-auto-sheet-date-change#1