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.