Convert birthdate to age with DATEDIF function

Question

In Excel I calculate age "Year" by DATEDIF function.

example: Born:15/08/1988

formula applied: =DATEDIF(A1,TODAY(),"Y")

result is "30-01-1900"

expected result should be "30"

[]

Answer 1

Your formula is perfectly fine but cells B1 and B2 are in date format. Select both cells, right-click, go to "Format Cells" and change the format to "Number".