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
|
|||
|
|||
Formula Excel
Wondering if someone would be able to help me with this:
A B C Year Year Service 01-Sep-89 30-Jun-10 = 21 Years Teachers From September 1, 1989 to June 30, 1990 = 1 Year of Service. I know it only 10 months, but that is their year. Is there a formula that could caculate the number of years from September 1, 1989 to June 30, 2010. -- Newfie |
#2
|
|||
|
|||
Formula Excel
The general formula for years between dates is
=Year(latest date) - Year(earlier date) and 2010-1989 = 21 years. So that might work for most cases? A complication arises if they begin, but don't finish a year, and so you need to know how to deal with partial years, such as from 01-Sep-89 through 15-Oct-10 That's 21 years of service plus a couple of months, so how do you want to handle that situation? "Newfie809" wrote: Wondering if someone would be able to help me with this: A B C Year Year Service 01-Sep-89 30-Jun-10 = 21 Years Teachers From September 1, 1989 to June 30, 1990 = 1 Year of Service. I know it only 10 months, but that is their year. Is there a formula that could caculate the number of years from September 1, 1989 to June 30, 2010. -- Newfie |
#3
|
|||
|
|||
Formula Excel
Yes, you are right some may leave at the end of December or the End of June.
But I am looking for a formula that will give us the total number of years of service. Maybe one formula will work for both? -- Newfie "JLatham" wrote: The general formula for years between dates is =Year(latest date) - Year(earlier date) and 2010-1989 = 21 years. So that might work for most cases? A complication arises if they begin, but don't finish a year, and so you need to know how to deal with partial years, such as from 01-Sep-89 through 15-Oct-10 That's 21 years of service plus a couple of months, so how do you want to handle that situation? "Newfie809" wrote: Wondering if someone would be able to help me with this: A B C Year Year Service 01-Sep-89 30-Jun-10 = 21 Years Teachers From September 1, 1989 to June 30, 1990 = 1 Year of Service. I know it only 10 months, but that is their year. Is there a formula that could caculate the number of years from September 1, 1989 to June 30, 2010. -- Newfie |
Thread Tools | |
Display Modes | |
|
|