If I use
=Year(Today()) - Year (A1)
then I get 3 as the answer. The actual value is between 2 and 3 so I want to get 2 as my answer.
I could also use:
=int((Today() - A1)/365)
but this does not take leap years into account.
Without writing a long and complicated formula, is there an easier way??