Calculate Length Of Service In Years And Months

BY STANLEY ZAROWIN

Q. Is there an easy way to calculate how long in years and months the employees have been working for my company?

A. Excel can do that, as long as you’ve listed all the employees in a database. If so, place them in an Excel worksheet with their start date in one cell and end date (which would be the current date, I assume) in an adjacent cell. Then insert this formula (where the start dates are in the D column and the end dates in the E column):

=DATEDIF(D2,E2,"y") & " years, " & DATEDIF(D2,E2,"ym") & " months ".

Here’s what it looks like in Excel (color added for clarity):

Be sure to format the D and E columns to display dates (see screenshot below).

QUIZ

Personal happiness and new hires’ pay on the rise

The news of the past couple of weeks hit home with reports on personal financial satisfaction and pay for finance professionals. See how much you know about recent news reports with this quiz.

SPONSORED REPORT

Preventing and detecting fraud at not-for-profits

Organizations in all industries must deal with the potential for fraud to occur, and design controls to prevent and detect it. Environment, policies, and controls can help organizations steer clear of problems.

PROFESSIONAL LIABILITY SPOTLIGHT

The dangers of dabbling

To meet evolving marketplace needs, CPAs often look to diversify their service offerings. Firms can mitigate the risk of experiencing competency-related professional liability claims by implementing these basic steps.