2 Replies Latest reply on Aug 10, 2017 7:29 AM by Jawad Hashmi

    how to calculate the number of business days between two dates?

    Paul Morgan

      I need to calculate the number of business days  (M-F) between two dates in order to know the age of an order.  I'm using

       

      DATEDIFF('day',[Date - Order], TODAY() )

       

      But this is showing me the number of calendar days, including Sat & Sun. 

       

      How should i modify my formula to do this?  I would name it "Days Old" and i would drop it on the colors card so i could show a bubble or bar vis showing the orders by their age in business days differentiated by color.

       

      Thanks in advance for you help!