Aug 07 2020 09:23 PM
Good Afternoon Everyone.
I am relatively new to Excel and would like someone's advice on writing a formula to do the following.
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
Aug 07 2020 10:43 PM
@Hannibals_Elephant You can use WORKDAY.INTL as demonstrated in the attached example.
Aug 07 2020 11:37 PM
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