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.