Add days to a date, include weekends, exclude public holidays

**clownfishcoxy** · 06-26-2019, 12:24 PM

I am trying to come up with a way of calculating a series of dates based on one initial data input. I have come up with a few ideas, but seem to be missing the ideal solution!

In essence I am trying to calculate a future date, which should land on the nearest 'business day', from an initial start date.

For example.

25 April 2019 + 5 days (including weekends, excluding public holidays) should = 30th May. The current solution i have is to use '=WORKDAY.INTL(D7,F7,1,$N$16:$O$23)-2' where d7 is the manually entered date, f7 if the number of days later and the table is a list of bank holidays with -2 to take account of the weekend omission by the formula. This however gives me an answer of the 5th of may as it counts 7 working days (7th May) and then removes 2 giving the answer of the 5th of May. If i do not use the WORKDAY.INTL formula, I dont seem to be able to 'omit' public holidays from the calculation.

I hope that makes sense and am hoping someone much brighter than me might have a solution!

Thanks!