There are two dates : 01-11-2008 and 28-02-2017 (in dd/mm/yy format). I want excel to calculate the difference between these two dates and give the output in whole years.
If the difference between months is greater than Six(6) months then it should be rounded of to one year or else ignore.
I have inserted the following formula which is giving the result of 9 years whereas it should be 8 years.
As to how 8 years are derived is shown as follows (dd/mm/yy):
01-11-2008 to 31-12-2008 -- 2 month 01-01-2009 to 31-12-206 -- 96 Months 01-01-2017 to 28-02-2017 -- 2 months total 100 months
100/12 = 8.33 i.e 8 years.
Can some body give me a correct formula on this please?