Print this page

Age in Years and Months

Knowledge Article Number 000100604
Description This Formula will determine Age based on the Birthdate field, in the following Text format:

## Years
or
## Years & ## Months
Resolution
IF(TODAY() >= DATE(YEAR(TODAY()), MONTH(Birthdate), DAY(Birthdate)),
TEXT(YEAR(TODAY()) - YEAR(Birthdate)),
TEXT(YEAR(TODAY()) - YEAR(Birthdate) - 1)) & " Years" &

IF(MONTH(TODAY()) = MONTH(Birthdate),
IF(DAY(TODAY()) >= DAY(Birthdate), "", " & 11 Months"),
IF(MONTH(Birthdate) > MONTH(TODAY()),
" & " & TEXT(12 - (MONTH(Birthdate) - MONTH(TODAY()))) & " Months",
" & " & TEXT(MONTH(TODAY()) - MONTH(Birthdate)) & " Months")) 




promote demote