| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation using a date
I have worksheets where I have a formula to calculate the number of years and
months of service. I would like to use that date to calculate excess annual leave hours. (Example: calculation shows at 23 years 4 months, I need to use this to calculate the following: 0 to 4 years =360; 5 to 9 years=624; 10-19 years=640; 20+ years=680) Note: The calculation for years and months will be different on each employee. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A specific date used for calculation of a new date | Excel Discussion (Misc queries) | |||
| Date Calculation (from entered date / 1yr later in next field) | Excel Worksheet Functions | |||
| End Date Calculation (adding a start date duration) | Excel Discussion (Misc queries) | |||
| Date calculation | Excel Discussion (Misc queries) | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Threaded Mode
