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.
With units of decades and the term "elapsed", I expect an integer result is
required. With your example of 26 years, 2 decades have elapsed; 3 decades
have not elapsed. IMO, the result must be 2, not 3.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
