Forum Discussion
Autofill dates while skipping cells (without formatting)
I'd do the following. It'll take a bit of time, but it is a one-time action.
Let's say the cell with Week 1 is B3
Enter the start date in the cell next to it, i.e. in C3.
In C4, enter the formula =C3+1 and fill down to C9.
In D3, enter the formula =C3 and apply the custom number format dddd to D3.
Fill down to D9.
In the cell next to the cell with Week 2, i.e. in C11, enter the formula =C3+7.
In D11, enter the formula =D11 and format as dddd.
Select C11:D11 and copy/paste to C12:D17, then to C19:D25, etc.
In the future, you'll only have to change the start date in C3 and all other dates will be adjusted automatically.
I'd do the following. It'll take a bit of time, but it is a one-time action.
Let's say the cell with Week 1 is B3
Enter the start date in the cell next to it, i.e. in C3.
In C4, enter the formula =C3+1 and fill down to C9.
In D3, enter the formula =C3 and apply the custom number format dddd to D3.
Fill down to D9.
In the cell next to the cell with Week 2, i.e. in C11, enter the formula =C3+7.
In D11, enter the formula =D11 and format as dddd.
Select C11:D11 and copy/paste to C12:D17, then to C19:D25, etc.
In the future, you'll only have to change the start date in C3 and all other dates will be adjusted automatically.
