Need help - I have been asked to create a spreadsheet for tracing team members vacation time. Please advise how can I create this spreadsheet? Thanks
1. Each team member of xyz team listed into columns/ rows however you see fit
2. A column/row for # of work days requested off (has to be a numerical value). For example, a two week vacation will be listed as 10 business days. A half-day will be listed as 0.5 days.
3. A column/row for the exact dates that the person will be OOO (for multiple days, this can be expressed as a date range)
4. A “sum” formula embedded into the spreadsheet that gives us totals of days/partial days taken off per person
1. Each team member of xyz team listed into columns/ rows however you see fit
2. A column/row for # of work days requested off (has to be a numerical value). For example, a two week vacation will be listed as 10 business days. A half-day will be listed as 0.5 days.
3. A column/row for the exact dates that the person will be OOO (for multiple days, this can be expressed as a date range)
4. A “sum” formula embedded into the spreadsheet that gives us totals of days/partial days taken off per person
Comment