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

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

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

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

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

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