Printer Friendly

Calculate length of service in years and months in Excel.

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


STANLEY ZAROWIN, a former Jof A senior editor, is now a contributing editor to the magazine. His e-mail address is
COPYRIGHT 2005 American Institute of CPA's
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2005, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

Article Details
Printer friendly Cite/link Email Feedback
Title Annotation:Technology Q&A
Author:Zarowin, Stanley
Publication:Journal of Accountancy
Date:May 1, 2005
Previous Article:Get a 10-key calculator on your PC.
Next Article:Protect against snoops reading "erased" track changes and comments.

Related Articles
The power of spreadsheets.
Spreadsheets face the millennium.
New release of Comeshare MPC. (Management News).
Comshare Inc. (Forecasting).
The role of technology in students' conceptual constructions in a sample case of problem solving.
Calculate future and past dates.
Bariatric bed.
What's going on inside an excel formula?

Terms of use | Copyright © 2017 Farlex, Inc. | Feedback | For webmasters