Hello,
My practice uses excel spreadsheets to track resourcing requirements on a week to week basis, this is done for an 18 month period. The week commencing date starts at Column C with the date in row 1. Column B notes employees names, each row has one employee name. The total hours per employee sit in column c in the relevant week date next to their name.
Can you help provide a code that deletes the week commencing date when the following week starts? Then I’d need (if possible) a code that adds a week to the end. I want the excel sheet to have a constant rolling 18 month period.
Thanks.![Folded hands :pray: 🙏](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f64f.png)
My practice uses excel spreadsheets to track resourcing requirements on a week to week basis, this is done for an 18 month period. The week commencing date starts at Column C with the date in row 1. Column B notes employees names, each row has one employee name. The total hours per employee sit in column c in the relevant week date next to their name.
Can you help provide a code that deletes the week commencing date when the following week starts? Then I’d need (if possible) a code that adds a week to the end. I want the excel sheet to have a constant rolling 18 month period.
Thanks.
![Folded hands :pray: 🙏](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f64f.png)