See this:
http://cpearson.com/excel/datedif.htm
Biff
"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.