Hi

I have the following table:

House Start End
08A 1-01-07 05-01-07
37E 1-01-07 05-01-07
04F 1-01-07 05-01-07
81E 1-01-07 05-01-07
32A 1-01-07 05-01-07
07A 1-01-07 05-01-07
29A 1-01-07 05-01-07
27C 1-01-07 05-01-07
15C 1-01-07 05-01-07
06F 3-01-07 07-01-07
32A 5-01-07 08-01-07
78C 5-01-07 13-01-07
32A 8-01-07 15-01-07
01D 12-01-07 15-01-07
01D 19-01-07 22-01-07
57B 19-01-07 22-01-07
35C 26-01-07 29-01-07
65A 26-01-07 29-01-07
03F 26-01-07 29-01-07

These are houses I lent and the begin and end date of the periode
somebody has rented the house. Now I would like to create a planning
sheet. For each month I would like a quick overview of which houses
are free and which are occupied.

Something like this
date - Jan 1 2 3 4 5 6 7
08A - X X X X - -
09A - - - - X X X
10A - - - - X X X

etc .etc

I've been working on something, but this requires me to create so many
help-cells and if then calculations, that it slows down the sheet
enormously and it is not easy to work with.

Would writing a program in VBA the easiest way to go? Does someone
maybe have some examples of this?

With kind regards
Gabrie