EXCEL FORMULA HELP

%3CLINGO-SUB%20id%3D%22lingo-sub-1574314%22%20slang%3D%22en-US%22%3EEXCEL%20FORMULA%20HELP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574314%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Afternoon%20Everyone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20relatively%20new%20to%20Excel%20and%20would%20like%20someone's%20advice%20on%20writing%20a%20formula%20to%20do%20the%20following.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3E%26nbsp%3BI%20have%20a%20product%20arriving%20for%20example%20on%2010%2F08%2F20%26nbsp%3B%20(Monday)%3C%2FLI%3E%3CLI%3EThe%20product%20needs%20to%20be%20dispatched%20on%20the%20third%20business%20day%20(13%2F08%2F20%20-%20Thursday)%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20write%20a%20formula%20so%20that%20when%20I%20enter%20the%20date%20a%20product%20arrives%2C%20it%20will%20indicate%20on%20what%20day%20it%20needs%20to%20be%20dispatched.%26nbsp%3B%20Where%20I%20am%20having%20difficulty%20is%20when%20a%20product%20arrives%20late%20in%20the%20week%2C%20I%20cannot%20find%20a%20way%20to%20write%20a%20formula%20that%20will%20skip%20the%20weekends%20(sat%20%26amp%3B%20sun)%20so%20that%20the%20dispatch%20date%20will%20still%20be%20the%20third%20business%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20would%20it%20be%20possible%20to%20build%20in%20Public%20Holidays%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20in%20advance%3C%2FP%3E%3CP%3EHannibal's%20Elephant%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1574314%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574376%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20FORMULA%20HELP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574376%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753220%22%20target%3D%22_blank%22%3E%40Hannibals_Elephant%3C%2FA%3E%26nbsp%3BYou%20can%20use%20WORKDAY.INTL%20as%20demonstrated%20in%20the%20attached%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574415%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20FORMULA%20HELP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574415%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Riny%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20for%20your%20quick%20reply.%26nbsp%3B%20That%20looks%20perfect%20for%20what%20I%20need.%26nbsp%3B%20Now%20all%20I%20have%20to%20do%20is%20work%20out%20how%20to%20write%20the%20formula%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 Replies

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

@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