Excel Autofill Showing Mondays ONLY in a calendar year

[S1]

Can someone share how I can use autofill, or any other formula to start on a
monday, and only show every monday (52 for the year) as the begining of each
week?

Thanks

 

[Bernie Deitrick]

S1,

Type in the date of the first Monday that you are interested in, say, in cell A2.

Then in the cell below (A3) use the formula

=A2+7

then copy that down for another 50 rows.

HTH,
Bernie
MS Excel MVP