Date Headers by week, incrementally

[AntBlabby8]

I'd like to create a dynamic row of headers, each with sequential Saturday dates, i.e., 7 days hence each time. But I want to be able to change the date in A1 by keying whatever it is, and all other headers to update automatically by a formulas. What is the formula that will do that? I put =A1+7 into B1 and it was fine, but when I dragged it across, every column said 01/15. (I thought this would be easy and obvious. Not so!) What is the formula for cell B1 that can be copied to C1 and so on?

Thanks

 

[rollis13]

In B1 you probably wrote =$A$1+7with absolute reference instead of relative reference. This would have worked too: =A$1+7

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Another thing that could cause the behaviour that you are describing is that you may have Calculation set to Manual.
Check that File -> Options -> Formulas - > Calculation options -> Workbook Calculation is set to Automatic.

 

[AntBlabby8]

In B1 you probably wrote =$A$1+7with absolute reference instead of relative reference. This would have worked too: =A$1+7

So nutty. I'm on a different laptop, and =A1+7 works perfectly! The laptop I had been working on when I had the problem was my new work laptop. Someone else's long-time weekly update file. I suspect the file has some other things going on that I didn't see, because the date increments not working came as a total surprise to me. But I'd been off work and Excel for 6 months (thank you, Covid layoff, ugh) and I thought my muscle memory had failed.

Stay safe and thanks so much!