Jan 05 2023 09:21 AM
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/2023 (increasing by 7 days based on the prior sheet's date) and so on for 52 weeks. I have found info on increasing by days and months but not weeks.
What is the formula for this?
Jan 05 2023 09:41 AM
SolutionThis 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
Jan 05 2023 09:41 AM
SolutionThis 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