1 Reply Latest reply on Dec 16, 2014 10:59 AM by alan sewell

    Just figure out a easy Net Work Day calculation

    Xiaojun Wu



      I just figure out a easy calculation for net work days between two dates. ( assuming 5 working days a week)


      Datediff('day',[First Date ],[Last Date])+1


      Datediff('week',[First Date ],[Last Date])*2

      -IF datename('weekday',[First Date])='Sunday' THEN 1 else 0 end

      -IF datename('weekday',[Last Date])='Saturday' THEN 1 else 0 end


      I am still woring on put any holidy in the formula. If you have any idea, you are wel come to imput.


      If you have any question, please let me know