Perhaps this site can point you in the right direction:
http://www.cpearson.com/excel/datetime.htm

tj

"Stevem" wrote:

I'm trying to calculate the time an employee has been with the company
broken into years, months, and days.
ie... cell A contains the employee's name , cell B contains their date of
hire, cell C contains the current date , and cell D should contain the
elapsed time.
problem is that the dozens of formulas I've tried don't completely do the
job.

I'm trying to calculate the time an employee has been with the company
broken into years, months, and days.
ie... cell A contains the employee's name , cell B contains their date of
hire, cell C contains the current date , and cell D should contain the
elapsed time.
problem is that the dozens of formulas I've tried don't completely do the
job.