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