Calculate length of service in years and months in Excel.
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 email@example.com.
|Printer friendly Cite/link Email Feedback|
|Title Annotation:||Technology Q&A|
|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.|