Help with formula

  • Thread starter Thread starter Stuck
  • Start date Start date
S

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
 
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
 
Back
Top