Remember Me?

#1
October 15th 07, 03:32 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2007 Posts: 2
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
October 15th 07, 03:35 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 3,268
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
news
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
October 15th 07, 03:42 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 4,624
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)?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Mein Excel Worksheet Functions 2 June 18th 07 08:03 AM Zahid Khan Excel Discussion (Misc queries) 2 April 3rd 07 09:13 PM greg2dan Excel Discussion (Misc queries) 1 February 12th 07 04:28 PM AAlvarez Excel Discussion (Misc queries) 3 February 8th 07 08:28 PM CPD174 Excel Worksheet Functions 4 July 8th 05 09:36 AM

All times are GMT +1. The time now is 01:08 PM.