Announcement

Collapse
No announcement yet.

networkdays.intl returns 1 if no dates entered

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • networkdays.intl returns 1 if no dates entered



    Hi Folks.

    I've been playing with the NETWORKDAYS.INTL formula to return the number of days between 2 dates including Saturdays but for some reason if no dates are entered in the two date cells the formula still returns a "1" for some reason, anybody got an idea why please?

    =NETWORKDAYS.INTL(B3,C3,11) is one version and =IFERROR(NETWORKDAYS.INTL(B3,C3,11),1) is another I've tried but both produce the same result.

    Kind regards and many thanks... :-)

    DezB

  • #2
    It is because both cells have same value (blank) so Excel sees them as the same date, therefore 1 whole day between them..

    try:

    =IF(SUM(B3:C3)=0,0,NETWORKDAYS.INTL(B3,C3,11))
    Last edited by NBVC; 6 days ago. Reason: typos
    Where there is a will there are many ways. Finding one that works for you is the challenge!

    MS Excel MVP 2010-2016

    Comment


    • #3


      Hi NBVC

      That's excellent, and thanks for the explanation which certainly helped as well.

      Apologies for the delay in getting back to you, I took some longed for time off to catch up on jobs at home. :-)

      Kind regards.

      DezB

      Comment

      Working...
      X