Its Friday, that means time for another Excel challenge for you.
This is based on yesterday’s employee vacation dashboard.
Calculate vacation days in a period:
Your mission, if you choose to accept it,Step 1: Download this workbook.
Step 2: Calculate number of vacations taken in a period. Specifically,
- How many vacations are taken between start & end dates, assuming complete vacation should be inside the start & end date period?
- How many vacations are taken such that at least one day of vacation is between start & end dates?
- How many people took vacations? (if same person took multiple vacations, then count it as 1)
- Use helper columns
- Any formula
- Play Mission Impossible music in background
- Drink no more than 2 cups of coffee
How to post your answers?
Simple, just post them in comments. Include explanation of your logic too if possible. Click here to post your answers.Need some clues?
We have them. See these links:GO!!!
0 comments:
Post a Comment