Neil
Replace 365,25 with 365.25

HTH
Cordially
Pascal

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

Thanks very much for that Papou
But i can't sem to get it to work. Maybe i am putting it in wrong but it
doesn't seem to like the 25.

Thanks though

"papou" wrote:

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