This will return decimal years;
=DATEDIF(A1,B1,"d")/365.25



WendyMc wrote:
I should have added that I have subtracted today's date then divided
by 365,
converted to a number field - but this seems a bit crude!

Thanks again

Wendy

"WendyMc" wrote:

Can anyone please help me? is there a function in excel to convert
Date of
Birth data into Age? or a forumula to help?

Many thanks
Wendy