Formula Function "NETWORKDAYS" has unexpected result when start date or end date is blank

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Normal
    • None
    • Affects Version/s: None
    • Component/s: ZSS Formula
    • None

      cell B30 : blank
      cell C30 : 1990/1/2

      Start Date is Empty
      =NETWORKDAYS(B30,C30)
      expected:<[1]> but was:<[2]>

      End Date is Empty
      =NETWORKDAYS(C30, B30)
      expected:<[-1]> but was:<VALUE!>

            Assignee:
            dennis
            Reporter:
            roliroli
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated: