Calculate completion date...NETWORK?

You'd use Workday function.

Assuming that you also don't work on holidays, you should use WORKDAY.INTL and supply list of holidays to the function.

Also, since Workday type of function can only deal with integer value for # of days. I assumed that decimal values should be spilled over to following workday.

So assuming that you have list of holidays in I2:I12 range... and that Sat & Sun are your weekend.
=WORKDAY.INTL(A2,ROUNDUP(C2,0),1,$I$2:$I$12)

See attached.

In D2 try:

=WORKDAY(A2,C2)

The NETWORKDAYS function takes a begin and end date and tells you the number of working days in between. It sounds like you want WORKDAY, which takes a start date and number of working days and gives you the end date.

Completion Date
=WORKDAY(A2,C2)

A third optional parameters is a list of holidays. You do not have holidays in your file so I didn't include it.

Hi,

One way

Formula:

Please Login or Register  to view this content.