Forum Discussion
Found some glitch in Formula "=NETWORKDAYS.INTL"
Rakesh891 Perhaps I'm not the best at explaining this but NETWORKDAYS.INTL calculates the number of working days between two dates. Let's say both start and end date are Tuesday, December 21 (ignore holidays). The function will return 1, because the one day period covers 1 working day.
WORKDAY.INT, on the other hand, counts the number of working days, as from (but excluding) the starting date. So, with the same start date it adds 1 day to arrive at Wednesday, December 22. The picture below demonstrates what happens in your specific example (start date 21-Dec, adding 8 working days with two different holidays).
Rakesh891 If I simply deduct one date value from another, let's say 21-Dec minus 21-Dec, the answer is zero. Mathematically 100% correct, but if I want to express the number of days covering the time period I would want to see 1. So, it is the human being at the keyboard who needs to decide which function to use, understand it and add 1 or not depending on the circumstances. Similar in your case. Two different functions, two different interpretations. It's your call.
- Yes true... But if i take holiday on 22nd then why answer change because total hoilday remain same
Rakesh891 Did you look at the picture I uploaded? With 21-Dec as a holiday, it coincides with the start date that is excluded anyway.