View original (French)

Datedif with negative result

Charlotte -  
Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   -
Hello,

Excel does not provide a response when the result of the calculation of the number of days between 2 dates is negative.
That is to say, the number of days between 2 dates is -15 for example.

How should I write my formula for it to work?

Thank you for your help,
Charlotte.

Configuration: Windows / Mozilla 11.0

2 answers

  1.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hello,

    look at this

    =INT(A1-B1)

    --
    A+
    Mike-31

    A period of failure is a perfect time to sow the seeds of knowledge.
    2
  2. Gyrus Posted messages 3360 Status Member 526
     
    Hello,

    With A1=10/10/2015 and A2=25/10/2015,
    you can write directly =A1-A2
    Result: -15

    Best regards,
    0