I am setting up a vacation roster and was using the networkdays.intl formula to calculate the number of days used per employee per month, excluding Saturdays, Sundays and bank holidays.
The formula was working until I got to one employee who went over the number of due days for the year, using one day from 2019. Instead of returning a -1 result (which is what I want to see) I'm getting a syntax # error.
Any suggestions?
For your further reference, this is how I have the roster set up
Column A - Employee name
Column B - Days brought forward from previous year
Column C - Days due for current year
Column D - Total days due
So my formula is D1-NETWORKDAYS.INTL(E1,F1,1,Holidays). The result should be the number of days remaining / carried forward to the next month or next year
Thanks in advance for your help
The formula was working until I got to one employee who went over the number of due days for the year, using one day from 2019. Instead of returning a -1 result (which is what I want to see) I'm getting a syntax # error.
Any suggestions?
For your further reference, this is how I have the roster set up
Column A - Employee name
Column B - Days brought forward from previous year
Column C - Days due for current year
Column D - Total days due
So my formula is D1-NETWORKDAYS.INTL(E1,F1,1,Holidays). The result should be the number of days remaining / carried forward to the next month or next year
Thanks in advance for your help
Last edited: