datedif count down before or after today

[pmvman]

Hi,
I have a list of service dates the can be either a future date or a past date?
I want to reference the today function and look at the list of dates and tell me how many months have passed between the two dates.i would like it to show say 30 months to go till next service or -30 because it has passed its due service date?
I have looked at the formula's on FAQs but they only work one way and dont give a negative value . i need it to show both positive and negative values in months wether it is 30 months before todays date or after it and automatically update each time i open the sheet or workbook

Many thanks in advance
Pmvman

 

[barry houdini]

Hello Pmvman, welcome to MrExcel, you could try this formula to give you negative or positive months

=DATEDIF(MIN(A2,B2),MAX(A2,B2),"m")*SIGN(B2-A2)

 

[pmvman]

Barry,
Thanks very much for the quick reply that formula has done the trick. That is exactly what i was looking for.
Many thanks again
cheers Pmvman