Hi Neil
With date of birth in A1, formula in B1:
=INT((NOW()-A1)/365,25)&" years"

HTH
Cordially
Pascal

"Neil" a écrit dans le message de news:
...
Hi

I have a date of birth in column A such as 01/01/1950, is there a way i
can
get it to show me the age in years say in column B. Compared to the date
today(that updates) or a fixed date such as 01/01/2007?

Many Thanks