Excel knows which years are leap years. To calculate with dates, see

http://www.cpearson.com/excel/datetime.htm#AddingDates

--
Kind regards,

Niek Otten

"Jason" wrote in message
...
I am creating an entry to calculate an annual longevity bonus. I am
definately a novice user. Everything I have read appears to be aimed at
those
with more experience than I have so I have difficulty understanding what
the
abbreviations mean and what some of the functions used actually do. I am a
freak for understanding what I am doing before I do it. The formula I am
using is '=INT((NOW()-G2)/365.25)' where G2 is hire date to get year of
service. So far, it appears this has been accurate for the sample data I
have
used, but intuition tells me there will be inaccuracy with some dates
because
there is no accounting for which year(s) in their history is a leap year.
I
think this would only matter if their hire date is within a few days of
"bonus calculation day", but I can't seem to confirm my suspicions yet.