Forum Discussion
arin0167
Jan 05, 2023Copper Contributor
Sequential weeks across sheets in excel
I have a workbook with 52 sheets for 52 weeks. In cell B2 on each sheet, I'd like to auto-populate that week's start date. The first sheet starts with 1/07/2023 in B2. The second sheet would be 1/14/...
- Jan 05, 2023
This formula presumes sheet 1 is for 1/7/23.
Enter the date of 1/7/23 manually in the first sheet in B2.
Next, group sheets to 2 to 52 then input this formula in B2 of sheet 2.
=DATE(2023,1,7)+(SHEET(A1)-1)*7
Patrick2788
Jan 05, 2023Silver Contributor
This formula presumes sheet 1 is for 1/7/23.
Enter the date of 1/7/23 manually in the first sheet in B2.
Next, group sheets to 2 to 52 then input this formula in B2 of sheet 2.
=DATE(2023,1,7)+(SHEET(A1)-1)*7
- arin0167Jan 05, 2023Copper ContributorTHANK YOU! Worked perfectly.
- Patrick2788Jan 05, 2023Silver ContributorYou are welcome!