That'll be because you're speaking a different language. Papou will
presumably have been using a comma as a decimal point, but you probably want
a full stop, so try
=INT((NOW()-A1)/365,25)&" years"

Another option would be
=DATEDIF(A1,TODAY(),"y")&" years"
--
David Biddulph

"Neil" wrote in message
...
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