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
Bookmarks