Help with formula

[Stuck]

Hi, does anyone know what the formula for the following
would be (or if it can be done):

In one column I want to insert a date of birth (Say,
Column A) and in the next column I want it to calculate
how hold that person would be in years (this would be in
column B)

So e.g. , it would be

10/2/59 44 years

Thanks heaps

 

[Guest]

Sure. This may not be the cleanest way to do it, but it
works:
Fomat Columns A and B as dates.
Enter date in A, enter today's date in B, formula for C =
(B5-A5). Then under cell format, go to custom, click
on "yy". This will give you only the years in Column C.
Mary

 

[Biff]

Hi Stuck,

Here's one way:

=DATEDIF(A1,TODAY(),"Y")

Biff