Holiday Planner show holiday taken?

I would like to create a holiday planner, that uses a worksheet for each
month, dates along the top, and name down the left handside. I envisage the
thirtenth worksheet, to carry the ongoing totals for holiday/sickness for
each employee. Here comes the real tricky bit, I would like it to change the
"H" for holiday to "T" for taken, dependant on todays date. So I could tell
how much holiday some has taken and how much is booked......any sugestions.

Hi mac5,

take a look at the spreadsheets available from http://www.big-yoy.co.uk/spreadsheets/holiday/index.php

they might be what you're after?