Edit Article

How to compute employee age and years of serving for your company without knowing query languages? There are many employee data management software and statistical computing software to help you. Here , take the smart calculator esCalc for example.

Ad

EditSteps

  1. Calculate Employee Age and Years of Serving with esCalc Step 1.jpg
    1
    Import employee data to esCalc. Click File > Open > Open file in other format (or .gex).
    Ad
  2. Calculate Employee Age and Years of Serving with esCalc Step 2.jpg
    2
    Append two new columns: Age and Serving Years. Just use function age() to compute the time interval. The way to compute them are similar, both are to compute a interval from a day to a current date. Enter function expressions in E2 and F2: =age(C2,now()), =age (D2,now()), press enter to check the result. Only need to enter one formula, all the other rows will also be computed out.
  3. Calculate Employee Age and Years of Serving with esCalc Step 3.jpg
    3
    Group by Department to check more clearly and do other computations. Select Sort before group option and click "OK" to check the result shown by departments.
    Ad


We could really use your help!

Can you tell us about
slipcovers?
Yes
No
slipcovers
how to make or buy a slipcover for a chair
Can you tell us about
wakeskating?
Yes
No
wakeskating
how to wakeskate
Can you tell us about
business operations?
Yes
No
business operations
how to retain customers
Can you tell us about
skateboarding?
Yes
No
skateboarding
how to ollie while moving
Thanks for helping! Please tell us everything you know about
...
Tell us everything you know here. Remember, more detail is better.
Tips
Provide Details.
Please be as detailed as possible in your explanation. Don't worry about formatting! We'll take care of it. For example:
Don't say: Eat more fats.
Do say: Add fats with some nutritional value to the foods you already eat. Try olive oil, butter, avocado, and mayonnaise.
Submit

EditRelated wikiHows

How to
Deal with Involuntary Retirement

How to
Calculate Your Real Hourly Wage

How to
Calculate How Much Money You Need to Retire

How to
Work Past Retirement Age

How to
Prepare an Employee Datasheet with EsCalc

Article Info

Categories: Workplace Management and Coping Skills

Thanks to all authors for creating a page that has been read 2,867 times.

Did this article help you?
Yes No

Become
an Author!

Write an Article