# if statement with networkdays error

1. ## if statement with networkdays error

Hi Guys .

I intially had the formula working without network days ( Column E) .In (column F) i needed to get the calculation to be done in networkdays. I managed to get the networkdays formula working for the first set of dates(Column A & B) . I need help in getting a statement that says if column A&B have no date value than look at Networkdays within( Column E & A ) and if not date value then state as " Not sent as yet"

=IFERROR(NETWORKDAYS(A3;B3;I4:I15);IF(ISNUMBER(C3);(C3);NETWORKDAYS(C3;\$BK\$1;I4:I15)))

2. ## Re: if statement with networkdays error

Hi,
Please review the file and let me know if this is the desired results.

3. ## Re: if statement with networkdays error

Yes this works. You are a champion. Thanks

4. ## Re: if statement with networkdays error

Hi Team.

I have encountered an issue on this file. ( Column BM323 should have stated a zero. ) That is when we calculate network days between column U & X we should have gotten a value. If there was no value then column BM must minus column U to get a number value .

Please can you help me on this thread. See attached. I highlighted columns in red.

5. ## Re: if statement with networkdays error

Hi
There is no attachment to your message....

Hi

See attached

7. ## Re: if statement with networkdays error

That's how excel calculates the days.
you have to reduce one if you dont want to include in your counting the starting date.

30-9 = 1
1.10= 2
2.10 = 3

8. ## Re: if statement with networkdays error

Hi

Thanks Belinda. Can you help me by adding it on the excel spread sheet?

9. ## Re: if statement with networkdays error

Originally Posted by belinda200
Hi,
Please review the file and let me know if this is the desired results.
Belinda - you have been asked before to outline the solution offered in the body of the thread as well as in the attachment. Please do so. Thank you for your co-operation.

10. ## Re: if statement with networkdays error

Thanks Ali. Apologises for the other thread comment. Did not know how to use the portal.

11. ## Re: if statement with networkdays error

Shiraz

This is a problem with dates. If the start and the end are the same date, should it show 1 or 0 as the duration.
And then the decision applies to all values above that
IF a hotel stay just records nights they would be the same for a one day stay, howeverever day of departure - day of arrival would be 1

you could -1 to all of your formulas or just the part with references BK1 which works out today

What is the model solution you require, and why would it be 0? bearing in mind today is now 2 days after you first posted? Do you mean 2?

12. ## Re: if statement with networkdays error

Sure Ali. I remember that, and making sure to comply since then. since this one was posted on April I have no option to edit now.

13. ## Re: if statement with networkdays error

=IF(ISBLANK(U323),"",IF(AND(ISNUMBER(U323)=FALSE,ISNUMBER(X323)=FALSE),"Not sent as yet",IF(AND(ISNUMBER(U323)=TRUE,ISNUMBER(X323)=TRUE),NETWORKDAYS(U323,X323,'Public Holidays'!\$A\$5:\$A\$16),IF(AND(ISNUMBER(U323)=TRUE,ISNUMBER(X323)=FALSE,ISNUMBER(BL323)=TRUE),NETWORKDAYS(U323,\$BK\$1,'Public Holidays'!\$A\$5:\$A\$16)-1))))

14. ## Re: if statement with networkdays error

Hi Belinda

Column BM323 is still not working. It should be 0 days taken and not 1 . See attached. What am I doing wrong ?

15. ## Re: if statement with networkdays error

Hi,
This is the correct formula.
You placed the (-1) in the wrong location.
``Please Login or Register  to view this content.``

16. ## Re: if statement with networkdays error

Hi Belinda. Any feedback on this thread request. Please add formula to the sheet for me .

17. ## Re: if statement with networkdays error

Hi,
see post #15...gave you the solution
copy the formula provided into your sheet