How do I determine a specific date based on a number of business days?

**mhodoh** · 02-11-2010, 03:10 PM

I'm documenting the steps of a process with each step accounting for a specific amount of business days. How do I determine the specific business day based on the number of days it takes to complete a process? For example: Start date then 45 business days from that date the next step begins...then 3 business days from that date the following step begins and so on... Please help!!

**NBVC** · 02-11-2010, 03:12 PM

Have a look at the Analysis Toolpak Addin function called Networkdays.

Go to Tools|Addins and check Analysis Toolpak to have access to this function and many more....

**DonkeyOte** · 02-11-2010, 03:16 PM

In this case I think you will want to use WORKDAY though like NETWORKDAYS this function forms part of the Analysis ToolPak.

**mhodoh** · 02-11-2010, 03:25 PM

Thanks so much. I've added the analysis toolpak but still have not been able to come up with the correct formula to calculate the date. I've used the networkday formula for this process but it may not be the correct formula to use in this case. I have a list of processes that has the number of business days it will take to complete each process. I have an end date and have calculated the date that each process should take place however I did not include business days nor holidays in the date calculation. So I may have to start over but not certain how to calcuate the date based on business days to complete the process. For example my start date is 7/20/10 and it takes 45 days to complete this process. What formula would I use to determine what date is 45 business days from 7/20/10? This will be used for each step of the process which is roughly around 21 steps.

**NBVC** · 02-11-2010, 03:44 PM

Another ATP function... WORKDAY()

Try:

=WORKDAY(A1,B1)

where A1 contains the start date and B1 the number of business days to add...

Note: You can use the Holidays parameter here too.