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.