Calculate Date that is X number of biz dates in the future

**tahoeast** · 11-19-2012, 03:46 PM

Hi, I'm going to tee this one up for you, probably 10 different ways to solve this: I want to take a date and calculate the date in the future that is X number of business days in the future. I've been attempting to use Networkdays plus a list of holidays and I'm getting there, however, I need a calc that will tell me the dates on a continual basis. For instance, I have a set of 100 dates and I want to know for each one of those, what date is 4 business days away, and what date is 40 business days away.

I've attempted creating a matrix of these dates and through some combo of index match, or possibly offset, I could get the date, but I KNOW there is a far easier way, perhaps an array. Look forward to hearing your ideas, thanks!

-----
Here is an example of what I want:

pic- 2012111934 11.45.jpg

**Pepe Le Mokko** · 11-19-2012, 03:48 PM

Hi
have a look at the WORKDAY function
(BTW posting a sheet is much easier for everybody than a picture)

**daddylonglegs** · 11-19-2012, 03:48 PM

Try WORKDAY function to add business days, the syntax is similar to NETWORKDAYS, i.e. with date in A2 add 4 workdays with

=WORKDAY(A2,4,HolidayRange)