Calculating Birthday's in One Cell

[renegade83]

1. Let's say I wanted to calculate someone's age in years in one cell how would I do this?

2. Let's say employee A has been with the company since 5/16/2006. Is there a way I can have the time to present show in the cell as Years Months and Days? I would also like this to be all in one cell.

Essentially I am trying to avoid having to clutter up the sheet with one cell with the date and than another cell with the equation.

Thank you in advance for your help!

[mudraker]

have a look at
http://www.cpearson.com/excel/datedif.aspx

[renegade83]

I tried the date difference function and all it gives me is a #NAME error. Any suggestions?

[mudraker]

Did you try something like this

=DATEDIF("28/12/1990",TODAY(),"y")&" years "&DATEDIF("28/12/1990",TODAY(),"ym")&" months "&DATEDIF("28/12/1990",TODAY(),"md")&" days"

Depending on your country & date format you may need to reverse the day & month