Hello all
Each month I sit down and work on my excel spread sheet for house hold bills.
I always save the sheets (I am just ocd I guess) each time I save the file as such:
January 2021 - February 2021
February 2021 - March 2021 .... and on and on.
When a new month of bills starts I simply open the last spreadsheet "Save As" and simply change the file name. This makes it consist.
But I am trying to figure out how to change JUST the month in each spreadsheet.
Here is an example:
Lets say these are all paid, I will now move to the next month, thus
B2 would need to change to 3/27/2021
B3 would need to change to 3/25/2021
B4 would need to change to 3/15/2021
B5 would need to change to 4/27/2021
B6 would need to change to 4/27/2021
B7 would need to change to 4/27/2021
I have tried to just add 30 days, but the problem is it wont be consistent as Feb may have 28 to 29 days, other months may have 30 or 31 so it will begin skewing the correct results.
I am not apposed to inserting a new column to the LEFT of A if that needs to be done, but I just cant figure it out. Also, I hear VBA? is a possibility, but I have never used VBA before.
Thanks
Tony
Each month I sit down and work on my excel spread sheet for house hold bills.
I always save the sheets (I am just ocd I guess) each time I save the file as such:
January 2021 - February 2021
February 2021 - March 2021 .... and on and on.
When a new month of bills starts I simply open the last spreadsheet "Save As" and simply change the file name. This makes it consist.
But I am trying to figure out how to change JUST the month in each spreadsheet.
Here is an example:
Lets say these are all paid, I will now move to the next month, thus
B2 would need to change to 3/27/2021
B3 would need to change to 3/25/2021
B4 would need to change to 3/15/2021
B5 would need to change to 4/27/2021
B6 would need to change to 4/27/2021
B7 would need to change to 4/27/2021
I have tried to just add 30 days, but the problem is it wont be consistent as Feb may have 28 to 29 days, other months may have 30 or 31 so it will begin skewing the correct results.
I am not apposed to inserting a new column to the LEFT of A if that needs to be done, but I just cant figure it out. Also, I hear VBA? is a possibility, but I have never used VBA before.
Thanks
Tony