Forums

Adjusted Service Date
General Forum
Adjusted Service Date
Discuss workforce management, performance management, retention, communication, motivation, contributing to business results and other topics.
Hi, Does anyone know the formula for calculating adjusted service dates. We have employees that we have laid-off and re-hired several times, and we are trying to figure out seniority. Any help would b
0
Cat:Topic ForumsForum:ForumId53
Cat:Topic ForumsForum:ForumId53Discussion:DiscussionId15877

Forums » Topic Forums » General Forum » Adjusted Service Date

You must be logged in to contribute. Log in | Register
 
Forums  »  Topic Forums  »  General Forum  »  Adjusted Service Date

Adjusted Service Date

posted at 8/11/1999 3:50 AM EDT
Posts: 9
First: 7/28/1999
Last: 9/28/1999
Hi, Does anyone know the formula for calculating adjusted service dates. We have employees that we have laid-off and re-hired several times, and we are trying to figure out seniority. Any help would be appreciated. Thanks
New post Reply to this post

Adjusted Service Date

posted at 8/11/1999 9:52 PM EDT
Posts: 90
First: 6/23/1999
Last: 9/26/2001
The way we have always done that is the following: Take the original date of hire and substract it out from the last date worked. For example if they were hired on April 22, 1993 and they last worked on August 10, 1998 they would have 5 years, 3 months and 8 days of service time for that time period. The easiest way to do this is as shown:
98 08 10
- 93 04 22
Be sure when you are substracting your days out to use 30 calendar days in a month. Some organizations will use the actual number of days per month. We have always assumed 30 for every month.

Then take that service time and back that date out of the new hire date. Say for instance in the example given above, that individual was rehired on February 21, 1999. You would do the following:

99 02 21
- 5 03 08
= 94 02 13
Which would result in an adjusted seniority date of February 13, 1994.

You have to keep in mind when doing your months, you have to use the "12" versus "10" like in normal math. It always works and is always correct to the day.

If you need more info or have questions, email me with your phone number and I will give you a call.
New post Reply to this post

Forums » Topic Forums » General Forum » Adjusted Service Date

Stay Connected

Join our community for unlimited access to the latest tips, news and information in the HR world.

  • Workforce Technology (Bi-weekly)

    Covering the latest technology trends, tools and applications that are shaping the workforce in the 21st century. Delivered the 2nd & 4th Thursday of each month.

  • Dear Workforce (Bi-weekly)

    See what HR professionals are asking, and what Workforce Management experts are saying. Delivered the 1st and 3rd Thursday of each month.

  • Workforce Benefits (Weekly)

    Stay current on all aspects of employee benefits, from health care to retirement issues. Delivered on Wednesdays.

  • Workforce Week (Weekly)

    Free weekly update on the trends in HR and new tools added to Workforce.com. Delivered each Tuesday.

  • Workforce Talent (Monthly)

    See the recruiting, talent development and retention strategies of top companies and get the resources for effective talent management. Delivered the 2nd Monday of each month.

  • Workforce Training (Monthly)

    Stay current on the latest strategies and resources for training and developing your workforce talent. Delivered the 3rd Monday of each month.

HR Jobs
View All Job Listings

Search