| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Eligible Vacation Days Calculator
Need to calculate if someone has worked X months since DOH, they are entitled
to X vacation days: over 6 months = 1 week vacation; over 1 year = 2 weeks; over 5 years = 3 weeks; over 10 years = 4 weeks; over 15 years = 5 weeks. D2 E2 F2 Date of Hire Today's Date =DATEDIF($D2,$E2,"m") Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vacation formula and 1/2 days | Excel Worksheet Functions | |||
| How do I add "accrued vacation days" column to the Employee Attend | Excel Worksheet Functions | |||
| I'm trying to count sick and vacation days | Excel Worksheet Functions | |||
| Keeping track of Sickdays, Vacation days, and hours for each. | Excel Worksheet Functions | |||
| How do I track vacation days on Excel? | Setting up and Configuration of Excel | |||
Threaded Mode
