Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-460

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Normal Normal
    • None
    • None
    • 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!>

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

              Created:
              Updated: