If that don't beat all............pretty cool Mike

Vaya con Dios,
Chuck, CABGx3




"Mike H" wrote in message
...
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?