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

Hi

One way
Enter 04/01/2010 in cell A1
in B1 enter
=IF(WEEKDAY(A1,2)=5,A1+3,A1+1)
and copy across as far as required
--
Regards
Roger Govier

"DUNNER7" <(E-Mail Removed)> wrote in message
news:9664D6BF-3196-44E6-B702-(E-Mail Removed)...
> 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
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4742 (20100104) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 4742 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com

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