First of all, allow me to apologize in advance if I am not supposed to post here.
I need help with networkdays.intl function. The formula I am using is:
=NETWORKDAYS.INTL(DATE($AN$5,1,1),EDATE(DATE($AN$5,1,1)-1,12),16,Settings!F4:F16)
I need to work with only 1 day per week off which is Friday. The holidays, as you can see, are listed in another tab named settings and total 13 days. However, the issue is that the year 2014 had 52 Fridays and added to the 13 other holidays, total working days should be 300. But my worksheet insists on showing 313 workdays.
And yes, the dates are formatted as dates, not as text.
Any help will be highly appreciated. Please let me know if you want to look at the worksheet itself.
Regards
I need help with networkdays.intl function. The formula I am using is:
=NETWORKDAYS.INTL(DATE($AN$5,1,1),EDATE(DATE($AN$5,1,1)-1,12),16,Settings!F4:F16)
I need to work with only 1 day per week off which is Friday. The holidays, as you can see, are listed in another tab named settings and total 13 days. However, the issue is that the year 2014 had 52 Fridays and added to the 13 other holidays, total working days should be 300. But my worksheet insists on showing 313 workdays.
And yes, the dates are formatted as dates, not as text.
Any help will be highly appreciated. Please let me know if you want to look at the worksheet itself.
Regards