How to calculate years of age knowing birth date

[ARTHUR_BENNETT]

I have 100+ children in an orphanage. Knowing the birth date (mm/dd/yr), how can I calculate their age in years to today?

[Andre_Zijlstra]

You can use this formula:

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

[ARTHUR_BENNETT]

Thank you Andre! Works like a charm!

[AlexWolfe]

I believe this equation should do the trick:

DATETIME_DIFF(TODAY(),Birthday,‘Years’)

Just replace ‘Birthday’ with your field name for their birthdays.

[AlexWolfe]

Woops, disregard my post, the forum site is loading funny for me; didn’t realize this had been answered!

[Andre_Zijlstra]

The same solution, twice.
That has got to be the right answer :grinning_face_with_big_eyes:

[Steve_Long]

Is there an easy way to modify this to give the age as of December 01 this season?

[Zach_Mortensen]

Anyone know why this formula wouldn’t work? I am getting an formula error message when I try to make a field with this formula. I have changed the field name to match my Birth Date field.

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

[M_k]

Hi @Zach_Mortensen

Did you make sure that you use quotes that are straight? Also, that you use the exact name of the field in the formula expression.

When creating a formula you have to setup a second field, using Formula field.

Those are a few things to check.

Mary

[Zach_Mortensen]

thank you! must have been the straight quotes. when I retyped each of them instead of pasting them it worked.