Date Function
 

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

Date Function
 

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

Date Function
 

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