column with all the working days of next year

[cpliu]

I'd like to create a column with all the working days of next year. I
put 1/1/2010 in the A1 then =A1+1 for A2, copy and paste to all other
cells. This would include weekends too. How can quickly create all the
working days?

Thanks,

 

[cpliu]

Sorry for posting before searching. It's Edit > Fill > Series > Type:
Date; Date Unit: Weekdays

 

[cpliu]

Sorry for posting before searching. It's Edit > Fill > Series >  Type:
Date; Date Unit: Weekdays

variation of the same question:
how can I fill the dates of all Fridays (or another day) of the year?
e.g.
12/4/2009
12/11/2009
12/18/2009
....

Thanks!

 

[Dave Peterson]

Put the first Friday (or any other day) that you want in the top cell (say A1).

Then use a formula like:
=a1+7
and drag down

(Format the cells with a nice date format.)