Date Function

  • Thread starter Thread starter DUNNER7
  • Start date Start date
D

DUNNER7

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 said:
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
Click to expand...

__________ 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
 
Back
Top