Printer Friendly
The Free Library
22,728,960 articles and books

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 A full-featured spreadsheet for Windows and the Macintosh from Microsoft. It can link many spreadsheets for consolidation and provides a wide variety of business graphics and charts for creating presentation materials.  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 See screen shot.  below).


STANLEY ZAROWIN, a former Jof A senior editor, is now a contributing editor A contributing editor is a magazine job title that varies in responsibilities. Most often, a contributing editor is a freelancer who has proven ability and readership draw.  to the magazine. His e-mail address See Internet address.

e-mail address - electronic mail address
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.

 Reader Opinion




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 © 2014 Farlex, Inc. | Feedback | For webmasters