SOLVED

Include Holidays as Working Days

%3CLINGO-SUB%20id%3D%22lingo-sub-2876338%22%20slang%3D%22en-US%22%3EInclude%20Holidays%20as%20Working%20Days%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2876338%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20make%20a%20calculation%20using%20workday%20and%20workday.intl%20functions%20and%20so%20far%2C%20so%20good%2C%20now%20I%20need%20to%20calculate%20what%20would%20be%20the%20end%20date%20taking%20into%20consideration%20holidays%2C%20when%20using%20the%20workday.intl%20function%20I%20know%20that%20it%20would%20exclude%20holidays%20as%20non-working%20days%20but%20this%20time%20I%20want%20excel%20to%20take%20those%20as%20working%20days%20as%20well.%20Is%20there%20any%20way%20to%20do%20so%20or%20is%20there%20any%20other%20option%20that%20I%20should%20use%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20insights%20would%20be%20highly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2876338%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2876378%22%20slang%3D%22en-US%22%3ERe%3A%20Include%20Holidays%20as%20Working%20Days%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2876378%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1193712%22%20target%3D%22_blank%22%3E%40Rodrigo12Rodriguez%3C%2FA%3E%26nbsp%3B%20WORKDAY.INT%20takes%204%20arguments.%20The%20%3CSTRONG%3Estart%20date%3C%2FSTRONG%3E%2C%20a%20%3CSTRONG%3Enumber%3C%2FSTRONG%3E%20of%20working%20days%20to%20add%20and%20two%20%3CU%3Eoptional%3C%2FU%3E%20arguments%20to%20indicate%20which%20days%20are%20considered%20to%20be%20the%20%3CSTRONG%3Eweekend%3C%2FSTRONG%3E%20and%20any%20%3CSTRONG%3Eholidays%3C%2FSTRONG%3E.%20Don't%20fill%20in%20the%20holiday%20argument%20and%20the%20function%20will%20not%20exclude%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20a%20formula%20like%20this%3A%3C%2FP%3E%3CP%3E%3CEM%3E%3CSTRONG%3E%3DWORKDAY.INTL(TODAY()%2C60)%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E....will%20add%2060%20working%20days%20to%20today's%20date%2C%20using%20the%20%3CSTRONG%3Edefault%20weekend%3C%2FSTRONG%3E%20setting%20and%20%3CSTRONG%3Eignore%20holidays%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2876428%22%20slang%3D%22en-US%22%3ERe%3A%20Include%20Holidays%20as%20Working%20Days%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2876428%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%2C%20highly%20appreciated%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone,

I'm trying to make a calculation using workday and workday.intl functions and so far, so good, now I need to calculate what would be the end date taking into consideration holidays, when using the workday.intl function I know that it would exclude holidays as non-working days but this time I want excel to take those as working days as well. Is there any way to do so or is there any other option that I should use?

Any insights would be highly appreciated.

2 Replies
best response confirmed by Rodrigo12Rodriguez (New Contributor)
Solution

@Rodrigo12Rodriguez  WORKDAY.INT takes 4 arguments. The start date, a number of working days to add and two optional arguments to indicate which days are considered to be the weekend and any holidays. Don't fill in the holiday argument and the function will not exclude them.

 

So, a formula like this:

=WORKDAY.INTL(TODAY(),60)

....will add 60 working days to today's date, using the default weekend setting and ignore holidays.

Thank you so much, highly appreciated