Excel - Calculate age from DOB in years, months days
in [Functions]
|
Prev: In excell 2003, increasing number of items shown in drop down list
Next: how do I convert date format yyyymmdd to mm/dd/yyyy
From: Polly on 10 Feb 2010 09:38 Might seem obvious but I can't find an answer in Excel Help. I am trying to calculate age in years, months and days by subtracting cell containing date of birth from cell containing today function. Using 2007. Many thanks.
From: Gary''s Student on 10 Feb 2010 09:46 See Calculating Age near the bottom of: -- Gary''s Student - gsnu201001 "Polly" wrote: > Might seem obvious but I can't find an answer in Excel Help. I am trying to > calculate age in years, months and days by subtracting cell containing date > of birth from cell containing today function. Using 2007. > Many thanks.
From: Glenn on 10 Feb 2010 09:46 Polly wrote: > Might seem obvious but I can't find an answer in Excel Help. I am trying to > calculate age in years, months and days by subtracting cell containing date > of birth from cell containing today function. Using 2007. > Many thanks. http://www.cpearson.com/Excel/datedif.aspx
From: Gary''s Student on 10 Feb 2010 09:48 See calculating age near the bottom of: http://www.cpearson.com/excel/datedif.aspx -- Gary''s Student - gsnu201001 "Polly" wrote: > Might seem obvious but I can't find an answer in Excel Help. I am trying to > calculate age in years, months and days by subtracting cell containing date > of birth from cell containing today function. Using 2007. > Many thanks.
From: Eduardo on 10 Feb 2010 09:49
Hi, I assume you have today() formula in D5 and entered the new date in E5 =DATEDIF(D5,E5,"y")&" years "&DATEDIF(D5,E5,"ym")&" months "&DATEDIF(D5,E5,"md")&" days" "Polly" wrote: > Might seem obvious but I can't find an answer in Excel Help. I am trying to > calculate age in years, months and days by subtracting cell containing date > of birth from cell containing today function. Using 2007. > Many thanks. |