"Roger Govier" wrote in message
...

"NCCDRLEE" wrote in message
...
I am trying to calculate the age of a person using the current "today's"
date
and their birthdate without typing today's date into a cell. I do not
need
the current date in a cell, due to having it in a footer. My thinking is
that it should look something like {=year(today)-year(birthdate)} I
cannot
get this to work. I have their birthdates typed into a cell, but do not
have
the current date.

If you only want the number of years, then you were almost there with your
formula
=YEAR(TODAY())-YEAR(A1)
where A1 is holding the birthdate.
You need to format the cell with the formula as General
FormatCellsNumberGeneral otherwise an age of say 44 would show as
13/02/1900

That would give the age which will be achieved by the end of this year,
rather than the more usual usage which is the number of whole years already
achieved by today's date, which you could get by
=YEAR(TODAY()-(A1))-1900
(formatted as number with no decimal places).

If you require the age split out into years, months days then follow
Biff's lead to Datedif, but do take note of some of its vagaries with
certain dates.
--
David Biddulph