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!
Bookmarks