| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula for years and months
If the formula for number of years is =Year(latest date)-Year(earlier
date) this formula only show the nubmer of years, and I would like it to show the number of years and months. I need help with this formula: A B C Year Year Service 01-Sep-89 31-Dec-09= 20 Years It should be 20 years 4 Months. (Remembering that teachers only work from September 1, to June 30, of each year a total of 194 days. 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 and months. -- Newfie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to caluclate the # of years and months between two dates | Excel Worksheet Functions | |||
| formula to caluclate the # of years and months between two dates | Excel Worksheet Functions | |||
| Formula that will represent years & months worked | Excel Discussion (Misc queries) | |||
| How do i convert years to months (formula) | Excel Worksheet Functions | |||
| how to calculate years, months by using one formula | Charts and Charting in Excel | |||
Threaded Mode
