How to calculate age

[bravo6]

Hello everyone!

I have created 3 columns. Born, Died, and Age. I want it to calculate the age, in the Age column. Is there a formula that can do this, but it should be something like 28 year's, 4 month's, 12 day's. If there is no data in Dead, then use the current date.

[TeeSee1]

https://support.google.com/appsheet/answer/10107326?hl=en&sjid=17809838876808543862-AP

You can build an expression using techniques described in the attached link.

As for selecting the Died or TODAY(), use ISBLANK() and IF()

[Suvrutt_Gurjar]

You may take a look at the following tip. Someone in that post thread has also calculated the days portion.

Convert Birthdate to Current Age in Years/Months f... - Google Cloud Community