Hi Everyone
Not sure what's wrong with my formula but I'm getting negative figures. I'm trying to find the difference in days between 2 same dates using NETWORKDAYS formula below and it keeps returning negative values. the range in G are the list of holidays. Any help with this? I'm expecting it to return 0. Thanks.
=(NETWORKDAYS(A1,B1,$G$1:$:$8))-1
COLUMN A COLUMN -B COLUMN_C
02/04/2019 02/04/2019 -1
Hi
I suppose you are using =NETWORKDAYS(A1,B1,$G$1:$G$8)-1
If in A1 and B1 you have 02/04/2019 the formula returns -1 if and only if in G2:G8 exists 2/04/2019.
An attachment would be easier as we can not see the values that are creating the result
the formula appears to be missing a G and having a random : in its place
=(NETWORKDAYS(A1,B1,$G$1:$:$8))-1
network days when the 2 values are the same will return 1 as in one day, if this day is a holiday, it will return a 0 as no days have been worked. the same would apply if both days were a weekend, no days have been worked
your formula takes 1 away from the networkdays calcuation, so you get an negative value.
It might be better to say what you are wanting to achieve, as the formulas are behaving as you would expect
Last edited by davsth; 06-24-2019 at 05:01 AM.
Hi Davsth, the formula seem to work fine with all same start and end dates except 22/04/2019 strangely. So for instance where I have start date 30/04/2019 and end date 30/04/2019, it returns 0
Only 22/04/2019 for both start/end date return -1
it works for me on the 22/4/19 it is a monday, but it was easter monday, so is it included in the list of holidays?
NETWORKDAYS is for business days only... is that what you want? Otherwise the DAYS() or DAYS360() functions will work as well.
Yes pls there is a 02/04/2019 in the lookup range because it's a holiday but was also a trading day.. Could that be the reason?
Last edited by FredFitzgerald; 06-24-2019 at 08:56 AM.
Yes izzy, I'm looking at just business days.
Yes, it's returning -1 because that day is in the list of holidays. Otherwise it would return 0 if you weren't subtracting -1 from the number. You could try something like...
Please Login or Register to view this content.
I agree with davsth.
It's time for a workbook upload.
Do you know how to do it?
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks