column with all the working days of next year

  • Thread starter Thread starter cpliu
  • Start date Start date
C

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,
 
Sorry for posting before searching. It's Edit > Fill > Series > Type:
Date; Date Unit: Weekdays
 
Sorry for posting before searching. It's Edit > Fill > Series >  Type:
Date; Date Unit: Weekdays
Click to expand...

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!
 
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.)
 
Back
Top