Thread: Date Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NCCDRLEE NCCDRLEE is offline
external usenet poster
 
Posts: 1
Default Date Formulas

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.