| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date formula rounded up
June 30, 2010
A B C D Birth Date Date of Hire Appt. Int/Act. Appt. VP November 22, 1962 September 1, 1988 N/A September 1, 1998 Total Admin Service Total Bd Service E F 11.84 21.84 I am usint June 30 , 2010 as the end date for the formula. From Sept 1,1998 to June 30 I get 11.84 years. this should be 11 years 10 months and then From Sept 1, 1988 to June 30, 2010 should be 21 years 10 months. I tried to round up but it would not let me. Can anyone help me figure this out. -- Newfie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add rounded numbers using the rounded value | Excel Discussion (Misc queries) | |||
| why is answer rounded up? | Excel Discussion (Misc queries) | |||
| how to display rounded number in a cell w/formula | Excel Discussion (Misc queries) | |||
| how do i add rounded numbers? | Excel Discussion (Misc queries) | |||
| Need formula to have date in cell B2 rounded to first of next mont | Excel Worksheet Functions | |||
Threaded Mode
