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

    Exclude Holiday from NetWorkDays


      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.