In B3 use the formula

=DATEDIF(B2,TODAY(),"y")

"mpenkala" wrote:

Hi there,

How can I create a formula that will determine how old someone is (in years)
if they enter their date of birth in another cell?

ex.

B2 is DOB = 01-01-1970
B3 needs is show age (36)

Thanks,
Matt