Hi,

You havent specified how you are going to count the years(like if the
difference in years is 26 , do you want the result as 2 or 3).If you
want result as 2 then use

=ROUNDDOWN(DATEDIF(B2,C2,"Y")/10,0)

where B2 has the start date and C2 has the end date.

If the result should be 3 then use

=ROUND(DATEDIF(B2,C2,"Y")/10,0)

where B2 has the start date and C2 has the end date.

Regards

Govind.


Saskia wrote:

For an assignment I'm asked to calculate how many decades have elasped
since a particular date.

Can anyone help me with this formula