LinkBack URL
About LinkBacks
Greeting everyone,
I wood like to know if there a way to figure out the number of years an employee has served based on hired day for next year (2015). See attachment for example
I would greatly appreciate your help
Greeting everyone,
I wood like to know if there a way to figure out the number of years an employee has served based on hired day for next year (2015). See attachment for example
I would greatly appreciate your help
Perhaps in D2 and copy down?
Formula:
=2015-YEAR(B2)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try this - formatted as general
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Fotis and Glen,
Both of your work worked perfectly. Thank you again for your time and help.
Fotis good too see you again!
............................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks