Calculating age in years and months from Date of Birth

  • Thread starter Thread starter dgray
  • Start date Start date
D

dgray

I think these formulas help me a lot, but I need the answer in years an
months, not decimals or days! Can you help?

To calculate the number of years from the date, enter the followin
formula in cell B1: =YEAR(TODAY())-YEAR(A1)

The result (rounded): 23 Years

For a decimal solution, use the following formula
=DATEDIF(A1,TODAY(),"m")/12

The result: 23.25 Years


To calculate the number of months from the date, enter the followin
formula in cell D1: =DATEDIF(A1,TODAY(),"m")

The result: 279 Month
 
Hi
try
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & "
months, " & DATEDIF(A1,NOW(),"md") & " days"

HTH
Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date of birth age formula 8
changed DOB to age, but if no DOB need cell to be empty. 4
Calculate age with an end date 3
Calculating time between mulitple dates 4
Update Upon Opening based on DATEIF NOW() 10
Year/Month/Date Question 4
how to calculate hrs flown in last one year 0
How do I calculate a persons age from birth dates 1

Back
Top