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.