How do I convert a list of date of births into age in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to convert a full list of date of births to be displayed as the
age. Is there a simple way to do this without subtracting each date from the
current date separately?
Thank you.
 
The only way I know is to subtract the current date from the DOB and format
it appropriatesly. There is no magic bullet for this one.
 
RON, the information you posted in response to my question seems helpful. I
am a windows 2000 user and cannot find a function called DATEIF. I have
however a function called YEARFRAC, can I use this as well? What do I write
at start date - end date and basis, and how do I calculate it for many cells
at once.
 
Hi
am a windows 2000 user and cannot find a function called DATEIF
Click to expand...

The name is DATEDIF

You can read on Chip Pearson his webpage that there is only documentation in Excel 2000 about this function.
You have to use a formula for every date cell you have

Maybe you like this Beta add-in that can insert a column with this formula for you
http://www.rondebruin.nl/datarefiner.htm
 
Ron - You are the best. I did install the data refiner and it converted a
list of 250 dates of births into accurate age in just a click! This is
great! There really are answers out here!
 
Hi Frinda,

To be more precise use this formula you will get No of years,No of month,No
of days.

=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months,
" & DATEDIF(A1,TODAY(),"MD") & " Days"

date should be in A1 cell


Regards,
Manjunath
 

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

Calculating age from date of birth and ignoring if blank 5
"how do I calculate age by using date of birth details" 5
Excel - Calculate age from DOB in years, months days 7
calculate date of birth with an end date and age 1
Converting Date of Birth to Age 8
How do I convert a date of birth to an age? 1
How do I post a result of a query to a text box? 0
Count/Calculation According to Age of the Person 1

Back
Top