View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One way:

=DATEDIF(A1,TODAY(),"y")


See

http://cpearson.com/excel/datedif.htm

In article ,
"Kane" wrote:

How would I determine years of service.... example is September 01, 1989?