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

      Guys,

       

      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