Excel - Calculate age from DOB in years, months days
 

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.

Excel - Calculate age from DOB in years, months days
 

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.

Excel - Calculate age from DOB in years, months 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.


http://www.cpearson.com/Excel/datedif.aspx

Excel - Calculate age from DOB in years, months days
 

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.

Excel - Calculate age from DOB in years, months days
 

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.

Excel - Calculate age from DOB in years, months days
 

Many thanks, it works.

"Eduardo" wrote:

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.

Excel - Calculate age from DOB in years, months days
 

Brilliant, thanks.

But why is it so difficult to find?

"Gary''s Student" wrote:

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.

Excel - Calculate age from DOB in years, months days
 

Many thanks - I now know how old I am!

"Glenn" wrote:

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
.