2 Replies Latest reply: Nov 28, 2017 11:35 AM by Eduardo Santos RSS

    Date interval excluding holidays but not weekends

    Eduardo Santos

      Hello,

       

      I have a table with a column that represents StartDate and another column that represents EndDate.

       

      My goal is to know the number of days between these two dates exluding holidays but not weekends.

       

      I have a separate table with a column saying all the holidays and weekends (excluding some saturdays) and also a variable with these values listed in the format : 'Date1', 'Date2', 'Date3' etc.

       

      I would highly appreciate if someone could help me out!