[Karl]

Hi,

I wonder if anyone can help. I have a table with three columns.

€¢ Column A shows the start date of a task
€¢ Column C shows the tasks duration
€¢ Column B adds the number of days in column C to the start date in column A
to arrive at the tasks end date.

I want column B, instead of adding €˜x number of days to the start date to
add €˜x number of working days. Can anyone tell me how to do this?

Ive been playing around with the NETWORKDAYS function, but cant find a way
to do just what I want.

Thanks

Karl

[dennis]

=TEXT(WORKDAY(A1,C1),"dd/mm/yyyy")

"Karl" wrote:


Hi,

I wonder if anyone can help. I have a table with three columns.

€¢ Column A shows the start date of a task
€¢ Column C shows the tasks duration
€¢ Column B adds the number of days in column C to the start date in column A
to arrive at the tasks end date.

I want column B, instead of adding €˜x number of days to the start date to
add €˜x number of working days. Can anyone tell me how to do this?

Ive been playing around with the NETWORKDAYS function, but cant find a way
to do just what I want.

Thanks

Karl

[David Biddulph[_2_]]

Did the OP ask for text? Why not just =WORKDAY(A1,C1) [formatted to suit
the OP's preferences] ?
That way, the OP will end up with a result on which he can do further
calculations if he wishes to do so.
--
David Biddulph

"Dennis" wrote in message
...
=TEXT(WORKDAY(A1,C1),"dd/mm/yyyy")

"Karl" wrote:


Hi,

I wonder if anyone can help. I have a table with three columns.

. Column A shows the start date of a task
. Column C shows the task's duration
. Column B adds the number of days in column C to the start date in
column A
to arrive at the task's end date.

I want column B, instead of adding 'x' number of days to the start date
to
add 'x' number of working days. Can anyone tell me how to do this?

I've been playing around with the NETWORKDAYS function, but can't find a
way
to do just what I want.

Thanks

Karl