Quizzes & Puzzles12 mins ago
Excel - Creating a Leave Calendar
I have about 50 staff and want to create a daily leave calendar in Excel that can show who is on leave and when, all at the same time. (maybe colour coded, do you think?)
I would also like to differentiate between different types of leave. eg: Annual Leave, Sick Leave, Leave without Pay.
Any idea's how and where to start with this?
I would also like to differentiate between different types of leave. eg: Annual Leave, Sick Leave, Leave without Pay.
Any idea's how and where to start with this?
Answers
Best Answer
No best answer has yet been selected by JessW. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.A column for each staff member.
A row for each day.
A colour for each type of leave.
You might be able do a conditional colour format based on a letter code for the type of leave. This would be easier to enter than a colour.
I would do it in Access database rather than Excel. This allows you to input the data in a form and manipulate the display in any way you need.
A row for each day.
A colour for each type of leave.
You might be able do a conditional colour format based on a letter code for the type of leave. This would be easier to enter than a colour.
I would do it in Access database rather than Excel. This allows you to input the data in a form and manipulate the display in any way you need.
I am sure you can find one someone has already designed.
A search in Google on "Excel Holiday Calendar" found quite a few hits.
Here is one (not free)
http://www.big-yoy.co.uk/spreadsheets/holiday/ index.php
And here is a page with loads of Excel calendars
http://www.docstoc.com/search/Excel-Holiday-Ca lendar/
A search in Google on "Excel Holiday Calendar" found quite a few hits.
Here is one (not free)
http://www.big-yoy.co.uk/spreadsheets/holiday/ index.php
And here is a page with loads of Excel calendars
http://www.docstoc.com/search/Excel-Holiday-Ca lendar/
What you want can't be done in excel (without some quite good programming skills)
you have a toolbar which should include the fill option ...
type in a date in b1 - grab the black dot (bottom right of the cell) and drag across 365 cells to your right
enter the names down column a
think up some colours.... freeze the top row and left column
select the cell - or range ... fill with the colour of your choice
and you are sorted.
alternatively
http://www.meadinkent.co.uk/xl-holiday-planner .htm
alternatively
50 staff - a reasonablr size firm .... get a consultant ... or one of the professional leave systems
it'll cost about �200 - 500
you have a toolbar which should include the fill option ...
type in a date in b1 - grab the black dot (bottom right of the cell) and drag across 365 cells to your right
enter the names down column a
think up some colours.... freeze the top row and left column
select the cell - or range ... fill with the colour of your choice
and you are sorted.
alternatively
http://www.meadinkent.co.uk/xl-holiday-planner .htm
alternatively
50 staff - a reasonablr size firm .... get a consultant ... or one of the professional leave systems
it'll cost about �200 - 500
You can get a free Excel leave calendar for 2011 and 2012 from these two links:
http://www.reviewmyli...taff-holiday-planner/
http://www.reviewmyli...planning-spreadsheet/
http://www.reviewmyli...taff-holiday-planner/
http://www.reviewmyli...planning-spreadsheet/
You can get a free Excel staff leave calendar for 2011 and 2012 from these links:
http://www.reviewmyli...taff-holiday-planner/
http://www.reviewmyli...planning-spreadsheet/
They have some basic formulas for calculating the number of remaining holidays.
http://www.reviewmyli...taff-holiday-planner/
http://www.reviewmyli...planning-spreadsheet/
They have some basic formulas for calculating the number of remaining holidays.
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.