| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Formulas
I need help...I'm trying to find a formula that will figure how many days and
employee will have based on how many years he/she has been employed. My spreadsheet looks something like this... Name Hire Date Years Employed Days Annual Leave Mr. Smith 8-28-1973 35 ? Annual Leave is aquired like this.. 1-2 years: 5 days, 3-7 years: 10 days, 8-14 years: 15 days, 15-19 years:20 days, 20-24 years: 25 days, 25 years or mo 30 days. Can anyone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas Not Working in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 Formulas ? | Excel Discussion (Misc queries) | |||
| Automated Formulas in Excel 2003 | Excel Discussion (Misc queries) | |||
| Automating Formulas in Excel 2003? | Excel Discussion (Misc queries) | |||
| Excel 2003 formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
