years of service

S

Shorty

Hi, I'm looking for a formula to calculate the years of service. If ones
hire date was 05/25/2004 then the designated cell needs to show "1". Thank
You
 
M

MS Office

Hi

Assuming that the year of service is recorded in Cell A1, try this formula
:-
=YEAR(TODAY())-YEAR(A1)

P.s. you may need to change the cell fromat to number ( Fromal > Cell >
Number)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Tricky question 5
Date some qualifies 2
Years of Employment 2
Calculating age from two date fields-Excel 2003 3
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Calculating time between mulitple dates 4
IF formula question - nesting multiple functions. 2
Date Formula 85 factor 7

Top