How to have Excel cells return age (Y/M/D) based upon DOB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob Roy - 17 Oct 2006 08:32 GMT

Based upon a date of birth input, can anyone advise how to populate three
cells with a person's age (cell 1 = years, cell 2 = months, cell 3 = days)
using Excel functions?

Reply to this Message

Roger Govier - 17 Oct 2006 08:51 GMT

Hi

Take a look at the undocumented Datedif function as clearly explained at
Chip Pearson's site
http://www.cpearson.com/excel/datedif.htm

Signature

Regards

Roger Govier

> Based upon a date of birth input, can anyone advise how to populate
> three
> cells with a person's age (cell 1 = years, cell 2 = months, cell 3 =
> days)
> using Excel functions?

Reply to this Message

Bob Phillips - 17 Oct 2006 08:54 GMT

=DATEDIF(A1,TODAY(),"Y")&" years "&DATEDIF(A1,TODAY(),"YM")&" months
"&DATEDIF(A1,TODAY(),"MD")&" days"

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Based upon a date of birth input, can anyone advise how to populate three
> cells with a person's age (cell 1 = years, cell 2 = months, cell 3 = days)
> using Excel functions?

Reply to this Message