Weekly Date Changes

[morph89]

Hello,

I have an excel file with dates for the week located across columns D5:H5 (only M-F). I need a macro that updates the these cells to the dates for the next week. Ideally this would update months/years at the beginning of a new month/year as well.

Any help is much appreciated!

[Pete_UK]

Take the value in D5 and add 7 to it - same for the other dates. Crossing into new months/years will be handled automatically.

Hope this helps.

Pete

[morph89]

Pete_UK,

Thanks for the quick response! I should preface that I don't have much experience with VBA however. What would this code look like? I tried using some other modules I found online but they only work within a single column, not across columns

[Pete_UK]

This is just one line of the macro:

Please Login or Register  to view this content.

Do think you could take it from there?

Pete

[morph89]

Alright, I got it working. Thank you!

[Pete_UK]

You're welcome.

Please mark the thread as Solved if you consider it to be so (click on Thread Tools above your first post).

Also, you can pass on thanks more directly to a contributor by clicking on the "star" icon in the bottom left corner of any post you have found to be helpful.

Pete

[morph89]

Thanks for the feedback. I was about to close this thread when I realized I have another dilemma.

How can I code this to save the excel file as a new file with a new name that would also change weekly ("12.3.12_12.7.12.xlsm" one week, then "12.10.12_12.14.12.xlsm" for the next week, for example)?

Again, any help is much appreciated

[Pete_UK]

I don't do much programming these days, so I'm a bit rusty, but I do see threads asking for that kind of thing quite frequently - maybe you can search for them.

Pete

[morph89]

I'll mark as solved for now and do some research. Thanks.