Excel - Creating a Leave Calendar

[JessW]

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?

[beso]

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.

[VHG]

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/

[VHG]

Here is a free "web based" holiday planner that looks good

http://public.whosoff.co.uk/

[ACtheTROLL]

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

[jamestuk]

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/

[jamestuk]

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.

[jamestuk]

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).