simple formula help

[tjtjjtjt]

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

tj

 

[David McRitchie]

Hi Steve,
See Chip Pearson's page
The DATEDIF Function
http://www.cpearson.com/excel/datedif.htm

Please use a meaningful subject title NONE of the word
have much to do do with the question. A subject title should
describe exactly as possible what you are looking for.

 

[Stevem]

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.