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.

```
=ROUNDUP((YEAR(LDate)-YEAR(EDate))+(IF(MONTH(LDate)-MONTH(EDate)>6,1,0))/12,0)
```

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?

`=ROUND((LDate-EDate)/365,0)`

this formula will do – yass Feb 19 '17 at 12:37