The data format of birth date column should be date format.

Suppose that cell A 1 is1970-01-0/,and cell B 1 takes the age (numerical format) formula: =YEAR(NOW())-YEAR(A 1.

Description:

Year(now ()): get the year of the current date,

Year(a 1): gets the year of cell a 1.

Subtract two years.

-

You didn't pay attention to my answer. Cell B 1 takes the age (digital format).