Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula Tips for Other Users

Topic Labels: Formulas
2322 3
Showing results for 
Search instead for 
Did you mean: 

For us newbies, is there a place where users are posting tips and techniques?

For example, I finally came up with a formula to determine someone’s age if you have their date of birth.

DATETIME_DIFF({D.O.B.}, TODAY(), “days”) / (-365)

Anyway, just thinking that there are a lot of experiences users who might want to share their own tips.

3 Replies 3

Me, again. Actually, that formula doesn’t exactly work because of leap years. You’d think dividing by 365.24 (the exact length of a year in days) would do the trick, but rounding doesn’t work when the birthday is just a day or two before/after the current date. So, who has the formula to determine a person’s age, knowing their date-of-birth?

I think this will do what you want:

DATETIME_DIFF(TODAY(), {D.O.B.}, “years”)

Good idea about a place for tips & techniques, I’ll pass it along!

Kasra, Well, of course. I wonder why I missed this obvious (now) solution.