The problem with that is that if you put in a birthday of 1-Dec-1950, it
will again show 57 years old using that formula (for any date in 2007),
whereas he would currently still be only 56.
--
David Biddulph

" wrote in
message ...
Dear Neil,

This works for me:

Simple method:
Date of Birth in Cell A1 = 01-Jan-1950
Today or any day in Year 2007 will be 57 years old.

In Cell B1 =YEAR(TODAY())-YEAR(A1)


More stuff:
Date of Birth in Cell A1 = 01-Jan-1950
Today, the date of birth will be approximately 57years 8 months

In Cell B1 =INT(DAYS360(A1,TODAY())/360-MOD(DAYS360(A1,TODAY())/360,1))

In Cell C1 =INT(ROUND(MOD(DAYS360(A2,TODAY())/360,1)*12,0))

B1 = 57
c1 = 8

HTH.

"Neil" wrote:

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