Hi,

You could do it with a macro but how about this instead.

Put your first date in A1 then the formula in b1
=WORKDAY(A1,1)
Drag right

If you get a NAME error then Tools|addins and check the analysys toolpak

or without the ATP put this in b1 and drag right

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

Mike

"DUNNER7" wrote:

Is it possible to to select row 1 in a spreadsheet and put the workday date
in each column w/o typing in each date individually?

Thanks,
Del Dobbs