Calculate age based on the birthdate

1

I’m trying to figure out a formula to calculate the age, in years and months, based on a birthdate. In excel I could use the datedif formula but I can’t find anything that works like that in Coda. Appreciate any help!

2

You can subtract the date from today. Column formula:

=Today()-yourBirthDateColumn

This will give you a result in days, but you can do further math to convert to years, or there may be some formatting you can apply to get it displayed in years and months.

3

Really, you can’t do better than this? Honestly?

4

Airtable Calc

DATETIME_DIFF(TODAY(), {Birth Date}, ‘years’)