Convert Birthdate to Current Age in Years/Months format

Calculating the current Age based on a date-of-birth column:
48%20AM

Formula
FLOOR(HOUR(TODAY()-[DOB])/365/24)&" yr "&
FLOOR(MOD((HOUR(TODAY()-[DOB])/24),365)*12/365) & " mo"

Line 1
HOUR(TODAY()-[DOB]) returns the number of Hours in the duration
/365/24 converts hours to years, and FLOOR gives the number of full years, dropping the decimal.

Line 2
(HOUR(TODAY()-[DOB])/24) returns the number of days in the duration
MOD((...),365) finds the remainder in days, after removing the full-years
FLOOR(MOD(...)*12/365) converts those remaining days to months, dropping the decimal.

This could also be used to show other durations, such as a count down to a future date.

3 Likes

Excelent, Thank you !!!

1 Like

Thank you very much for sharing.

1 Like