Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate a person's age on a specific date? (huge roster
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)? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate a person's age on a specific date? (huge roster
One way:
A1: <birthdate B1: 09/01/2007 C1: =DATEDIF(A1,B1,"y") & " yr. " & DATEDIF(A1,B1,"ym") & " mo's." In article , babylonian007 wrote: 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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what's the best way to calculate a person's years of age in excel | Excel Worksheet Functions | |||
I want to calculate Sundays between a specific date & today () | Excel Discussion (Misc queries) | |||
How to calculate person's age from DOB and current date? | Excel Discussion (Misc queries) | |||
how calculate the date someone had to be born to have a specific a | Excel Discussion (Misc queries) | |||
How to calculate a person's age taking into account their birthda. | Excel Worksheet Functions |