"Workdays"

G

GNaipaul

I have colomn with start date(Column A), Column C = duration Column B =
Column a + Column C

I would like exclude Saturday and Sunday of the week

How can I do That?

Please Help
 
B

Bill Kuunders

=WORKDAY(A1,C1)
you will need to have the analysis tool pak installed as an addin
Greetings from NZ
Bill K
 
F

Fred Smith

Is it safe to assume that the duration in Column C is working days, and you want
Column B to be the date that is the number of Column C working days after the
start date?

If so, use the Workday function:

Column B =Workday(a1,c1)

You may need to load the Analysis Toolpak to access this function
(Tools>Addins...)
 
Top