| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
(YEARS) Excel Formula
I am trying to use the YEAR function in excel. I need to figure out (years of
service) between the original Hire date and the current date. EX 11/01/1961 - original hire date 2/08/2008 - current date Need a formula that will get me to the answer of (47 years) I copied the formula below into excel =YEAR(A3)-YEAR(A2) and I entered 2008 (in cell A2 and the original hire date is in cell N5), when I hit enter to submit the formula I got "#####". What did I do wrong??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
(YEARS) Excel Formula
Maybe
=DATEDIF(A1,A2,"y") Where A1 is the earlier date. Mike "Kellie" wrote: I am trying to use the YEAR function in excel. I need to figure out (years of service) between the original Hire date and the current date. EX 11/01/1961 - original hire date 2/08/2008 - current date Need a formula that will get me to the answer of (47 years) I copied the formula below into excel =YEAR(A3)-YEAR(A2) and I entered 2008 (in cell A2 and the original hire date is in cell N5), when I hit enter to submit the formula I got "#####". What did I do wrong??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
(YEARS) Excel Formula
=DATEDIF(A2,A3,"y") shows 46 as we haven't got to Nov yet.
-- Gary''s Student - gsnu200768 "Kellie" wrote: I am trying to use the YEAR function in excel. I need to figure out (years of service) between the original Hire date and the current date. EX 11/01/1961 - original hire date 2/08/2008 - current date Need a formula that will get me to the answer of (47 years) I copied the formula below into excel =YEAR(A3)-YEAR(A2) and I entered 2008 (in cell A2 and the original hire date is in cell N5), when I hit enter to submit the formula I got "#####". What did I do wrong??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Years Day formula? | Excel Discussion (Misc queries) | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel | |||
| Change Xcel Amortization from 30 years to 40 years? | Excel Discussion (Misc queries) | |||
| Excel Formula - Compute Number of Years Worked | Excel Discussion (Misc queries) | |||
Hybrid Mode
