Track vacation time for team members

[MrMarkyMark]

FTFY

Scooty is a whizz at Excel-based summation. Sas would be overkill. Why splash out on Blue Nun when you can get away with the Bucky?

[NotAllThere]

That's the kind of job I'd outsource to India.

[vetran]

That's the kind of job I'd outsource to India.

can't they would get the date wrong

[SimonMac]

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

Shouldn't be too difficult, call it half a day so £250 + any expenses, let me know what you think and I can draw up an invoice for you

[TheFaQQer]

Shouldn't be too difficult, call it half a day so £250 + any expenses, let me know what you think and I can draw up an invoice for you

Do you use Excel to do your invoices?

[northernladuk]

Have you raised a CUK ticket, if not please do the needful at the soonest.

He has but PC is busy carrying out other duties his client has asked him to so so won't be escalated to a second line team for awhile.

[GJABS]

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

Talk about re-inventing the wheel. Just do a Google on "employee vacation spreadsheet" and look through the hundreds of spreadsheets that have already been written, most of which can be used for free.

[vetran]

Talk about re-inventing the wheel. Just do a Google on "employee vacation spreadsheet" and look through the hundreds of spreadsheets that have already been written, most of which can be used for free.

or SharePoint templates a far better solution being Multi-User.

[darmstadt]

or SharePoint templates a far better solution being Multi-User.

Not everyone has SharePoint but nearly everyone has Excel (or equivalent). I could provide my COBOL application to do this

[cojak]

But think of IR35!!!!