Formula to Calculate date difference between random workdays

[maranoqu]

Hello everyone,

I have a question. If let's say i have a coworker that works on 4 days of the week : let's say he works on monday, wednesday, saturday and sunday. I want to calculate the amount of days this person is not working during his holiday/vacation.

Datediff is a good tool but it calculates full weeks. i want to be able to calculate the difference between two dates, let's say these 2 dates : 05-06-2018 till 05-07-2018. now he only works 4 days a week not 7. is there a formula that is able to calculate the exact amount of days he is free.

here is an example sheet.

Best,

Marano

[Phuocam]

Try:

=NETWORKDAYS.INTL(J2,K2,"1010011")