11 Replies Latest reply: Jul 17, 2012 9:20 AM by Naveed Ul Haq RSS

    Difference between two dates

    Janine Pottbrock

      I would like to know if it is possible with a formula to calculate the difference between two dates.

       

      For example, I have these two dates: 2012-07-05 and 2012-07-11

       

      Now in my chart there should be the number 6 to get to know that for example one order is in progress for 6 days.

       

      Can anyone explain how to do it?

       

      Thanks a lot!