How to have Excel cells return age (Y/M/D) based upon DOB

R

Rob Roy

Based upon a date of birth input, can anyone advise how to populate three
cells with a person's age (cell 1 = years, cell 2 = months, cell 3 = days)
using Excel functions?
 
B

Bob Phillips

=DATEDIF(A1,TODAY(),"Y")&" years "&DATEDIF(A1,TODAY(),"YM")&" months
"&DATEDIF(A1,TODAY(),"MD")&" days"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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

Excel - Calculate age from DOB in years, months days 7
Error message needed if incorrect Date Of Birth (DOB) entered 5
Count/Calculation According to Age of the Person 1
Calculating Current Age from DOB 3
The IF function but with 3 values 6
Accumulating Attendance Base upon Age Group 5
Producing Age Based on Date of Birth 1
Calculating age from a DOB field 4

Top