View original (French)

Calculation in days between 2 dates, even negative.

NDO -  
Yoyo01000 Posted messages 1720 Registration date   Status Member Last intervention   -
Hello,
I use the function =DATEDIF(Q2944,R2944,"D")
to calculate the number of overdue days between two dates (the payment date compared to the due date)
It works

but I also want to display negative results and I get an error ... error: #NUM!
for example, a client should pay on September 30, and he pays on September 20, basically I want to see -10

Thank you for your help!

1 answer

  1.
    Yoyo01000 Posted messages 1720 Registration date   Status Member Last intervention   168
     
    Hello,
    in that case, there's no need to use DATEDIF

    You can just do =Q2944-R2944

    it will give you a result in number of days, which you can change if you want a result in weeks for example.
    1
    1. Yoyo01000 Posted messages 1720 Registration date   Status Member Last intervention   168
       
      0
    2. NDO
       
      Thank you very much, it was so easy! :)
      Have a nice day.
      0
      1. Yoyo01000 Posted messages 1720 Registration date   Status Member Last intervention   168 > NDO
         
        We sometimes love to make things more complicated for ourselves ^^

        Remember to mark the topic as [Solved] ;)

        Have a nice day.
        0