MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calculating full actual months

Posted by stan on January 02, 2002 5:59 PM

Anyone have any idea how to do the following:

I have a start date and and end date and I need a formula that will give me actual months (preferably rounded down).
For example, start date Jan 31, 2000; end date feb 28, 2001, result = 12. But, start date jan 31, 2000; end date march 1, result =13.

Any guidance much appreciated.

Posted by Aladin Akyurek on January 02, 2002 6:37 PM

Stan --

In C1 enter: =DATEDIF(A1,B1,"M")

where A1 houses the start date and B1 the end date (that is, A1 < B1),

would give you the right result almost in all cases



Posted by Tom D on January 02, 2002 10:00 PM

Not a perfect solution, but =INT((later date - early date) / 30 will give you the number of "30 day" months between the dates.

Posted by stan on January 03, 2002 9:04 AM

Thanks a million Aladin - you are a lifesaver!