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).