Hi,

With your start date in a1, put this in B1 and drag down

=WORKDAY(A1,1)

If you get the name error then Tools\Addins and check the analysis toolpak

or without the ATP

=A1+1+CHOOSE(WEEKDAY(A1+1,2),0,0,0,0,0,2,1)

Mike

"Confusicous" wrote:

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?