Calculation in days between 2 dates, even negative.

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

  • Votes
  • Date
  • Descending date
  1. 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. Thank you very much, it was so easy! :)
      Have a nice day.
    2. @NDOWe sometimes love to make things more complicated for ourselves ^^

      Remember to mark the topic as [Solved] ;)

      Have a nice day.