Exclude start date while calculating number of work days?

[ravi123]

Hello Everyone,

Greetings for the day!

I'm looking for the solution in calculating number of days in which start date could be excluded.
Note: putting "-1" in function will not work as I'm already excluding Sundays and Holidays. If work starts on Sundays or on any holidays "-1" will further decrease number of work days.

Use Case:

Start day : 22 Oct 18 [A1]
Function: =NETWORKDAYS.INTL(A1,TODAY(),11,'Bank Holidays'!$M$2:$M$40)

This function returning the value of 2, however I want it to be only 1 workday (today is 23 Oct).

Any help in this regard!,
Thanks for going through it.

 

[Rick Rothstein]

Re: How to exclude start date while calculating number of work days?

I'm looking for the solution in calculating number of days in which start date could be excluded.
Note: putting "-1" in function will not work as I'm already excluding Sundays and Holidays. If work starts on Sundays or on any holidays "-1" will further decrease number of work days.

Use Case:

Start day : 22 Oct 18 [A1]
Function: =NETWORKDAYS.INTL(A1,TODAY(),11,'Bank Holidays'!$M$2:$M$40)

If you don't want to count the start date, then give the NETWORDAYS.INTL function the next day as its start date. You would do that by using A1+1 instead of A1 as the first argument.

 

[ravi123]

Re: How to exclude start date while calculating number of work days?

If you don't want to count the start date, then give the NETWORDAYS.INTL function the next day as its start date. You would do that by using A1+1 instead of A1 as the first argument.

Hi Rick,

This works! Done! That was such a simple yet great solution. Thank you very much. Cheers.