[Solved] Calculate age in years, months, days

[ApacheAsg]

How to calculate age in years, months, days in openoffice. I got the years using the formula

=YEARS(VALUE(I3);NOW();0)

but having difficulties putting it all together with the months, and days preferably in this format: 15Y, 5M, 5D. Thanks all.

[Zizi64]

Substract the date of birth from the value NOW(). Then format the result as you want or extract the Years, Months, Days.

[ApacheAsg]

I'm more of a visual learner, so I had no luck from the reading instructions, but I did try it and it did not work for me still.

"Substract the date of birth from the value NOW()." and section D, but to no avail.

=YEARS(VALUE(G3);NOW();0)&=MONTHS(VALUE(G3);();0)& (it did not work)

So need additional assistance. See attached. Thanks again.

[Zizi64]

Here are another two approaches:

Age.ods

(23.72 KiB) Downloaded 132 times

I am using the function TODAY() instead of the NOW(). (The NOW() will refresh in every seconds, when you enter new data.)
The result of the substraction will not be exact, because the difference will "hide" the leap years. You can not detect - based on the diference - how many leap years was in the life of the actual person.

I think, the another approach/solution works better.