What formula do I use to get individuals ages from their birthday

If I have a list of birthdays (05/31/1987) is there a formula that will
translate this into age (19 yrs, x days)?

See Chip Pearson's great webpage on the DATEDIF function:

http://www.cpearson.com/excel/datedif.htm

(there's a section on calculating a person's age there)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"akucolor" wrote:

> If I have a list of birthdays (05/31/1987) is there a formula that will
> translate this into age (19 yrs, x days)?

Try Chip Pearson's site: http://www.cpearson.com/excel/datedif.htm

="("&datedif(birthday,now(),"y")&"yrs,"datedif(birthday,now(),"yd")&")"
should give the format you asked for.

"akucolor" wrote:

> If I have a list of birthdays (05/31/1987) is there a formula that will
> translate this into age (19 yrs, x days)?

See Chip Pearson's great webpage on the DATEDIF function:

http://www.cpearson.com/excel/datedif.htm

(there's a section on calculating a person's age there)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"akucolor" wrote:

> If I have a list of birthdays (05/31/1987) is there a formula that will
> translate this into age (19 yrs, x days)?

Try Chip Pearson's site: http://www.cpearson.com/excel/datedif.htm

="("&datedif(birthday,now(),"y")&"yrs,"datedif(birthday,now(),"yd")&")"
should give the format you asked for.

"akucolor" wrote:

> If I have a list of birthdays (05/31/1987) is there a formula that will
> translate this into age (19 yrs, x days)?