Oct 22 2021 09:48 PM
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.
Oct 22 2021 10:08 PM
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.
Oct 22 2021 10:08 PM
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.