Difference between two dates in months with decimals

  • Thread starter Thread starter effem
  • Start date Start date
E

effem

Daniel,

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

Bernie's solution seems to be complete and correct.

Effem
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference between two dates in months with decimals 3
Help Calculating Partial Months between 2 dates. 2
Calculating monthly start date with a start date 3
Need to count dates in a spreadsheet 4
DATEDIF vs. simple difference 5
calculating months between dates 4
Why does excel calculate difference in days from February - March 3
Difference between two months 5

Back
Top