Jump to content

# Calculating Years

This topic is 4384 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

• Newbies

I hope someone will be able to help me with this calculation. I'm trying to calculate employees Lenght of Service (LOS).

Example, if an employee 1 started in 1994 and Employee 2 started in 2001. I want to calculate there total years so employee 1 would be at 17 years and employee 2 at 10 years and have it calculate each year. How do I create that formula. Any help would be greatly appreicated.

##### Share on other sites

I hope someone will be able to help me with this calculation. I'm trying to calculate employees Lenght of Service (LOS).

Example, if an employee 1 started in 1994 and Employee 2 started in 2001. I want to calculate there total years so employee 1 would be at 17 years and employee 2 at 10 years and have it calculate each year. How do I create that formula. Any help would be greatly appreicated.

Depending on how your start date is stored, you can do a couple things.

Year(Get(CurrentDate)) - Year(empStartDay) - This works if the empStartDay is a date field or a timestamp field.

Year(Get(CurrentDate)) - Year(GetasDate(empStartDay)) - This works if the empStartDay is a text field, depending on format.

##### Share on other sites

• Newbies

Thank you so much! That worked perfectly!!

##### Share on other sites

This topic is 4384 days old. Please don't post here. Open a new topic instead.

## Create an account or sign in to comment

You need to be a member in order to leave a comment

## Create an account

Sign up for a new account in our community. It's easy!

Register a new account

## Sign in

Already have an account? Sign in here.

Sign In Now
×
×
• Create New...

## Important Information

By using this site, you agree to our Terms of Use.