Include Holidays as Working Days

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, whe...

excel

office 365

Riny_van_Eekelen
Oct 23, 2021
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.

Riny_van_Eekelen

Platinum Contributor

Oct 23, 2021

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.

Rodrigo12Rodriguez

Copper Contributor

Oct 23, 2021

Thank you so much, highly appreciated

Forum Discussion

Include Holidays as Working Days

Resources