How do I calculate the age of a subject based on their DOB?

's Computer Specifications

I want excel to calculate the age of a subject by entering the date of birth
of such subject

's Computer Specifications

See the "Calculating A Person's Age" section of Chip Pearson's website:

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"Gdm/kmf" wrote:

> I want excel to calculate the age of a subject by entering the date of birth
> of such subject

's Computer Specifications

Assuming your birthday is in A1

=DATEDIF($A$1,NOW(),"Y")&" Years, "&DATEDIF($A$1,NOW(),"YM")&" Months,
"&DATEDIF($A$1,NOW(),"MD")&" Days"

"Gdm/kmf" wrote:

> I want excel to calculate the age of a subject by entering the date of birth
> of such subject

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
new folder based on subject	dymusi	Microsoft Outlook VBA Programming	2	25th Jul 2011 05:24 PM
Not junk email - based on subject only	Jason	Microsoft Outlook Discussion	1	9th Jul 2008 04:57 AM
calculate min in col B subject to text in col A	=?Utf-8?B?V3ZS?=	Microsoft Excel Worksheet Functions	10	7th Feb 2007 07:52 AM
Subject: how to calculate time in a payroll worksheet- Revisited	=?Utf-8?B?RGFsZVAx?=	Microsoft Excel Programming	0	15th Jul 2005 07:59 PM
block mail based on subject	Brian	Microsoft Outlook	0	26th Jan 2004 02:50 AM