Need Networkdays.intl formula to return negative value (1 Viewer)

Tophan

Registered User.
Local time
Today, 09:07
Joined
Mar 27, 2011
Messages
362
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
 
Last edited:

Tophan

Registered User.
Local time
Today, 09:07
Joined
Mar 27, 2011
Messages
362
Figured it out...so simple an error it is embarrassing

As I was working with dates, I had the number format set to custom so when I entered this formula it was trying to convert it to a customized date format. I changed it to number with 0 decimal places and it worked.
 

Users who are viewing this thread

Top Bottom