EXCEL FORMULA HELP

[Hannibals_Elephant]

Good Afternoon Everyone.

I am relatively new to Excel and would like someone's advice on writing a formula to do the following.

•  I have a product arriving for example on 10/08/20  (Monday)
• The product needs to be dispatched on the third business day (13/08/20 - Thursday)

I would like to write a formula so that when I enter the date a product arrives, it will indicate on what day it needs to be dispatched.  Where I am having difficulty is when a product arrives late in the week, I cannot find a way to write a formula that will skip the weekends (sat & sun) so that the dispatch date will still be the third business day.

Also would it be possible to build in Public Holidays as well.

Many thanks in advance

Hannibal's Elephant

[#2]

@Hannibals_Elephant You can use WORKDAY.INTL as demonstrated in the attached example.

[#3]

@Riny_van_Eekelen 

Hi Riny

Thank you so much for your quick reply.  That looks perfect for what I need.  Now all I have to do is work out how to write the formula