See Chip's site about this
http://www.cpearson.com/excel/datedif.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"UMMY" wrote in message ...
Ineed to calculate an age from a given date of birth calculated to the
current date. Should the birthday pass the current date then the age should
also change