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
Aladin
======
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!
