General discussion

  • Creator
    Topic
  • #2305555

    Count Working Days in Excel

    Locked

    by bjjhome.bt ·

    Hi All

    I have been asked to help one of the staff I support with a problem calulating working days. I dont know if this is podssible except with a huge IF statement. Does anyone know of a way to define and count WORKING days.

    Thanks in advance

All Comments

  • Author
    Replies
    • #3359070

      Count Working Days in Excel

      by dklippert ·

      In reply to Count Working Days in Excel

      Go to Insert>Function. In the Date & Time category, scroll down to Networkdays. If you don;t see it, go to Tools>Add-Ins and make sure the Analysis ToolPak is checked.
      The syntax for Networkdays is:
      =NETWORKDAYS(StartDate,EndDate,Holidays)
      You can set up a range of Holidays that will be excluded from the count. See the Help file

    • #3359318

      Count Working Days in Excel

      by bjjhome.bt ·

      In reply to Count Working Days in Excel

      This question was closed by the author

Viewing 1 reply thread