"Workdays"
 

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

"Workdays"
 

=WORKDAY(A1,C1)
you will need to have the analysis tool pak installed as an addin
Greetings from NZ
Bill K
"GNaipaul" wrote in message
...
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

"Workdays"
 

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
(ToolsAddins...)

--
Regards,
Fred


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