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.

Hi Frieda

You can use this function with the date in D5
=DATEDIF(D5,TODAY(),"Y")

See this site for more information
http://www.cpearson.com/excel/datedif.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Frieda" wrote in message ...
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.
"Frieda" wrote in message
...
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.

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.


"Ron de Bruin" wrote:

Hi Frieda

You can use this function with the date in D5
=DATEDIF(D5,TODAY(),"Y")

See this site for more information
http://www.cpearson.com/excel/datedif.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Frieda" wrote in message ...
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.

Hi

am a windows 2000 user and cannot find a function called DATEIF

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Frieda" wrote in message ...
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.


"Ron de Bruin" wrote:

Hi Frieda

You can use this function with the date in D5
=DATEDIF(D5,TODAY(),"Y")

See this site for more information
http://www.cpearson.com/excel/datedif.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Frieda" wrote in message ...
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.

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!

"Frieda" wrote:

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.

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

"Frieda" wrote:

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.