Difference between two dates in months with decimals
 

Daniel,

Thanks for your feedback, but after trying, it seems your solution has
a problem with dates in February and March and forgets to count one
month.

Bernie's solution seems to be complete and correct.

Effem.


--
effem
------------------------------------------------------------------------
effem's Profile: http://www.excelforum.com/member.php...o&userid=16112
View this thread: http://www.excelforum.com/showthread...hreadid=275586

Hi,

Thanks for the feedback.

It failed on any dates where DAY(A1) DAY(B1).

You can try :

=(DATEDIF(A1,B1,"m")+(DAY(A1)DAY(B1))-DAY(A1)/(32-DAY(A1-DAY(A1)+32))+
DAY(B1)/(32-DAY(B1-DAY(B1)+32)))*1000

If this one fails, I'd appreciate if you'd let me know for which dates (and the
expected results).

Regards,

Daniel M.


"effem" wrote in message
...

Daniel,

Thanks for your feedback, but after trying, it seems your solution has
a problem with dates in February and March and forgets to count one
month.

Bernie's solution seems to be complete and correct.

Effem.


--
effem
------------------------------------------------------------------------
effem's Profile:
http://www.excelforum.com/member.php...o&userid=16112
View this thread: http://www.excelforum.com/showthread...hreadid=275586