Formula for Target Completion Date

[VictoriaM575]

Hello!

I'm not Excel savvy and I need your help. I am trying to see if there is a formula for Target Completion Date (TCD) for various QA Laboratories projects, if I have a Start Date and if I were given an estimated time (in days, weeks, months, etc.) to complete a specific project. Given this information, how do I come up with TCD minus holidays and weekends.

Let's say, the labs started received a request for testing (Start Date) on 7/1/11 and they tell me that it takes about 18 weeks to complete the testing. Based on this information, I want to calculate the Target Completion Date (in net working days = excluding holidays and weekends). Is this doable?

Your help is greatly appreciated!

 

[Jose_Chasez]

The NETWORKDAYS function can do this. Check Excel's online help and note that you may need to install the Analysis toolpack.

 

[Aladin Akyurek]

Hello!

I'm not Excel savvy and I need your help. I am trying to see if there is a formula for Target Completion Date (TCD) for various QA Laboratories projects, if I have a Start Date and if I were given an estimated time (in days, weeks, months, etc.) to complete a specific project. Given this information, how do I come up with TCD minus holidays and weekends.

Let's say, the labs started received a request for testing (Start Date) on 7/1/11 and they tell me that it takes about 18 weeks to complete the testing. Based on this information, I want to calculate the Target Completion Date (in net working days = excluding holidays and weekends). Is this doable?

Your help is greatly appreciated!

A2: 7/1/11

B2: 18

Holidays is a range housing relevant holiday dates.

Nivoke:

=WORKDAY(A2,B2*7,Holidays)

The important thing here is how to decide that B2 is in weeks. The formula assumes weeks, hence the multiplier value of 7.