4 Replies Latest reply: Sep 27, 2014 12:15 PM by Jon Vance RSS

    Exclude Holiday from NetWorkDays

      Hi,

      I have a very helpful expression I got from the community that returns the number of work-days since the beginning of the month:

       

      =NetWorkDays (Date# ('9/1/2014', 'M/D/YYYY') , Today())

       

      But it does not account for company holidays.

       

      I do have a column called COMPANY_HOLIDAY with values Y or N.

       

      I would like to add the COMPANY_HOLIDAY Y into the expression so it would NOT count a NetWorkDay if it is flagged as a Y in COMPANY_HOLIDAY.

       

      I tried this, but returned nothing...

       

      =NetWorkDays (Date# ('9/1/2014','M/D/YYYY'), COMPANY_HOLIDAY = 'Y'), Today())

       

      I would welcome ideas.

      JV