If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel leap year question
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. |
#2
|
|||
|
|||
Excel leap year question
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. |
#3
|
|||
|
|||
Excel leap year question
Niek Otten wrote:
Excel knows which years are leap years. To calculate with dates, see As long as the employee wasn't hired in 1900 ;-) Jerry |
#4
|
|||
|
|||
Excel leap year question
I'm in Life insurance. I calculated the chance this being the case and
decided not to raise the issue. Maybe I should have. Kind regards, Niek Otten "Jerry W. Lewis" wrote in message ... Niek Otten wrote: Excel knows which years are leap years. To calculate with dates, see As long as the employee wasn't hired in 1900 ;-) Jerry |
#5
|
|||
|
|||
Excel leap year question
Yes, but I'd love to have his pension ;-)
Jerry Niek Otten wrote: I'm in Life insurance. I calculated the chance this being the case and decided not to raise the issue. Maybe I should have. Kind regards, Niek Otten "Jerry W. Lewis" wrote in message ... Niek Otten wrote: Excel knows which years are leap years. To calculate with dates, see As long as the employee wasn't hired in 1900 ;-) Jerry |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
Excel Range Value issue (Excel 97 Vs Excel 2003) | Keeno | General Discussion | 2 | June 13th, 2005 02:01 PM |
WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
Excel EULA question - automated creation of reports | Rekonn | General Discussion | 2 | October 25th, 2004 10:31 AM |
Question for the most *Sagacious* Excel users | Steve Kay | Worksheet Functions | 2 | September 23rd, 2003 08:34 PM |