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

When given start date is later than end date In NETWORKDAYS(), it returns #NAME?

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.0.0 RC
    • 3.0.0 RC
    • ZSS Component

      Problem Description:

      When given start date is later than end date In NETWORKDAYS(), it returns #NAME?. However, if this is an invalid case, it should return invalid value.

      Reproducing Steps:

      1. run Spreadsheet
      2. enter =NETWORKDAYS(DATE(2013,6,2),DATE(2013,6,1))

      Actual:
      the cell shows #NAME?.

            hawk hawk
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: