View Single Post
  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default How do I subtract a date from a date for a sum of total years?

You can find lots of info at Chip Pearson's site:
http://www.cpearson.com/excel/datedif.htm

(=datedif() was only documented in xl2k's help.)



Paige wrote:

I am trying to calculate how many years an employee has worked. I have start
date and current date. What is the formula to return years worked?


--

Dave Peterson