One way........
1-Fill the cells down for the year including the Saturdays and Sundays
2-Re-format the column to "Custom dddd" so the names of the days will show
3-Data Filter Autofilter and choose "Saturday" from the dropdown
4-Delete those rows
5-Choose "Sunday" from the dropdown
6-Delete those rows
7-Data Filter Autofilter to return to normal
8-Reformat the column for the date style you prefer.

Vaya con Dios,
Chuck, CABGx3




"Confusicous" wrote in message
...
I need to start with the date 12/28/2009 (monday) and drag down to
12/31/2010
(Friday) but I need to skip Saturday and Sunday. Is there an easy way to
do
this?