| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What formula do I use to get individuals ages from their birthday
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)? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What formula do I use to get individuals ages from their birthday
Try Chip Pearson's site: http://www.cpearson.com/excel/datedif.htm
="("&datedif(birthday,now(),"y")&"yrs,"datedif(bir thday,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)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| Getting 106 for Birthday Formula | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
Linear Mode
