Donate SIGN UP

Excel - Creating a Leave Calendar

Avatar Image
JessW | 01:34 Tue 25th Nov 2008 | Computers
7 Answers
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?
Gravatar

Answers

1 to 7 of 7rss feed

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.
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/
Here is a free "web based" holiday planner that looks good

http://public.whosoff.co.uk/
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 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/
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.
Sorry for my accidental double post - it didn't seem to work the first time, but the second time I tried the two answers appeared. I hope the editor can delete my first answer (and this one too! - just leaving the middle one would be good).

1 to 7 of 7rss feed

Do you know the answer?

Excel - Creating a Leave Calendar

Answer Question >>

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.