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
|
|||
|
|||
Date Formula 85 factor
Hi
A1 September 1, 2010 Years of Services Age A2 B2 C2 D2 E2 F2 G2 H2 Birth Date Date of Hire Years Mths Days Years Mths Days Nov 22, 1962 Sept 1, 1988 22 0 0 47 9 10 Aug 7, 1969 March 23, 1995 12 5 9 41 0 25 85 Factor G2 H2 I2 Years Mths Days 53 5 34 I was adding both of the columns, but when it came to a employee with information's in all three columns it did not work. I am looking for a formula that will give me an 85 Factor as of September 1, 2010. Age plus Years of Service. Can anyone help? thank you -- Newfie |
Thread Tools | |
Display Modes | |
|
|