Or Try This
Enter Date of Birth In Cell A1

And Paste this formula in any Cell
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
DATEDIF(A1,NOW(),"md") & " days"

Claude


"Neil" wrote:

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