Calculate Length Of Service In Years And Months


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).


Year-end tax planning strategies

Practitioners should consider the timing of income and deductions, avoiding the net investment income tax, donating to charity, and planning for retirement.


Effortless payroll service offerings

In this special focus report, experts explain how payroll providers can help CPAs help their clients. Sponsored by Paychex, Intuit, SurePayroll, ADP, BenefitMall and AccountantsWorld.


Return due dates changed in highway funding bill

The federal highway funding extension bill signed into law on July 31 contains several tax provisions, including changing the due dates for partnership, S corporation, and corporate tax returns.