G Guest Apr 28, 2006 #1 I want excel to calculate the age of a subject by entering the date of birth of such subject
G Guest Apr 28, 2006 #2 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
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
G Guest Apr 28, 2006 #3 Assuming your birthday is in A1 =DATEDIF($A$1,NOW(),"Y")&" Years, "&DATEDIF($A$1,NOW(),"YM")&" Months, "&DATEDIF($A$1,NOW(),"MD")&" Days"
Assuming your birthday is in A1 =DATEDIF($A$1,NOW(),"Y")&" Years, "&DATEDIF($A$1,NOW(),"YM")&" Months, "&DATEDIF($A$1,NOW(),"MD")&" Days"
