Sequential weeks across sheets in excel

[arin0167]

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? 

[#2 · Accepted solution]

@arin0167 

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

[#3]

THANK YOU! Worked perfectly.

[#4]

You are welcome!