Excel Autofill Showing Mondays ONLY in a calendar year
 

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

Excel Autofill Showing Mondays ONLY in a calendar year
 

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


"S1" (donotspam) wrote in message
...
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