Negative Datedif

I want to find the difference between two dates in months. I can do this by using the datedif formula, however I need this to have the ability to give a negative difference. If it is negative it brings back an error in the cell, can I not use datedif if the difference is negative?

datedif is not on this computer but perhaps something like

=if(a1>b1,datedif(a1,b1,"mm"),-datedif(b1,a1,"mm"))

Regards

Dav

Originally Posted by Dav

datedif is not on this computer but perhaps something like

=if(a1>b1,datedif(a1,b1,"mm"),-datedif(b1,a1,"mm"))

Regards

Dav

That is pure genious mate!!! Thanks very much!!!!

People pay for advice like that

I was trying to do something similar but not quite. The solution above didn't work for what I was doing, and I couldn't find a solution anywhere but this is what finally worked:

=IFERROR(DATEDIF(D5,"01/01/2014","M"),-DATEDIF("01/01/2014",D5,"M"))

where D5 contains the date I'm comparing to 1/1/14

If D5 = 3/1/2014 the result is -2
If D5 = 3/1/2013 the result is 10

-Paul Falcon