Leap year spreadsheet

[Shirley Drew]

Can someone help me with a spreadsheet. I need to figure
years of service for all employees and when they reach
different years of service. How do I do that with leap
years?

[Wilson]

Every company that I'm familiar with just uses years and the hire date? One
extra day every 4 years? Or, use 365.25 days per year?
"Shirley Drew" <sd...@duraflame.com> wrote in message
news:442901c1fde3$0307c950$36ef2ecf@tkmsftngxa12...

[Peo Sjoblom]

What is the problem? If you want to check years you can use something like

=date(year(a1)+b1,month(a1),day(a1)

where a1 would hold the start date and b1 the number of years, assume they start on 2/29/00 (for a1),
if you put 5 in b1 you'll get 3/01/05, if you want to see how long someone has worked from start date
until today, with start date in a1

=datedif(a1,today(),"Y")&" Year(s) and "&datedif(a1,today(),"YM")&" Month(s)"

will give you years and months since somebody started using the computer's date for today.

--
Regards,

Peo Sjoblom

"Shirley Drew" <sd...@duraflame.com> wrote in message news:442901c1fde3$0307c950$36ef2ecf@tkmsftngxa12...

[J.E. McGimpsey]

How do you define "years of service".

If your start date is in A1, and end date in A2, you could use

=DATEDIF(A1, A2, "y")

Then if

A1: 2/29/2000
A2: 2/28/2002
A3: =DATEDIF(A1, A2, "y") ====> 1

if
A2: 3/1/2002
A3: =DATEDIF(A1, A2, "y") ====> 2

OTOH, if

A1: =3/1/2002
A2: =2/29/2004
A2: =DATEDIF(A1, A2, "y") ====> 1

in addition, if it's for ERISA purposes, there are often
statutory/regulatory/plan definitions of YOS that depend on hours/days
worked per calendar year, or when the first month is counted, etc.

In article <442901c1fde3$0307c950$36ef2ecf@tkmsftngxa12>, Shirley Drew

[J.E. McGimpsey]

You've obviously never dealt with HR and benefit plans - there are
often 401K plan, COBRA, statutory or regulatory definitions of YOS
that vary considerably from actual dates.

For instance, at one company I worked for, a YOS for the 401K plan
(determining vesting schedules) was any calendar year for which the
employee worked 1000 hours (and it was more complicated if there the
employee left and came back within a certain period). But for vacation
calculations, the actual dates were used, and for the ESOP, there was a
third calculation for beginning of eligiblility, based on the first day
of the first month after hire. And don't even get me started on
unemployment insurance calcs...

In article <O5tPSRe$BHA.1108@tkmsftngp04>, Wilson <jwi...@wickes.com>
wrote: