how do i get a list of only the begining of weeks in excel?

F

F4Forte

I want to make a list of saturday and in the autofill option i do not see
this options? Ideas?
 
P

Pete_UK

Put a Saturday date in A1 and format it as a date. Then in A2 enter:

=A1+7

and copy this down for as many weeks as you need.

Hope this helps.

Pete
 
Top