2 Replies Latest reply: Jan 8, 2018 7:14 AM by Sunny Talwar RSS

    Calculate Date Subtraction

    Nur Mahirah Aqilah

      I wanted to subtract between dates and the result should be in days.


      The data in my excel is


      payment_start_date = 01-11-2017

      payment_end_date = 30-04-2018


      I used the lines that I have found in one the forums.




      But the duration came out not the way I wanted , I have attached the picture.


      I need some help as I am quite new with this.