View original (French)

Datedif with negative result

Charlotte -  
Mike-31 Posted messages 18405 Registration date   Status Contributeur 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 réponses

Réponse 1 / 2
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 145
 
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
Réponse 2 / 2
Gyrus Posted messages 3360 Status Membre 526
 
Hello,

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

Best regards,
0