View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default How do I calculate a person's age on a specific date? (huge roster

http://www.cpearson.com/excel/datedif.aspx


--

Regards,

Peo Sjoblom




"babylonian007" wrote in message
...
I have a huge roster of children and want to caluclate each child's age (in
years and months) on the first day of school 09/01/2007.
For example, if a particular child's birthday is on 7/5/2004, her age in
years and months is " 3 yr. 2 mo's.)

How do I calculate a person's age on a specific date (09/01/2007)?