I'm wanting to use Excel to create a visual representation of what people I have working on what projects and for how long.

Name | Project | Start | End Date | cels I want to fill (1 week per "x")

John | Proj A | 1/1/06 | 2/28/06 _|__xxxxxxxx
John | Proj B | 1/15/06 | 2/28/06 |____xxxxxx
John | Proj C | 2/1/06 | 3/28/06 _|______xxxxxxxx
John | Proj D | 4/1/06 | 5/31/06 _|__________xxxxxxxx
Sally | Proj A | 1/1/06 | 2/28/06 _|__xxxxxxxx
Sally | Proj B | 1/15/06 | 2/28/06 |____xxxxxx
Sally | Proj C | 2/1/06 | 3/28/06 _|____xxxxxxxx
Sally | Proj D | 4/1/06 | 6/1/06 __|__________xxxxxxxx

So I hope the above formats well enough to give a rough illustration. I'd like to input a equations to the cels on the right that result in an "x" in each cel based on whether or not it falls between the start and end dates.

If I change the start or end date I'd like it to auto-fill the x's accordingly, so the result is a visual representation of usage of employees on given projects.

I forsee the headers for the "x" columns to be months, broken down in to weeks, as follows (notice 5 weeks in March):

MONTHS___Jan-06|Feb-06|_Mar-06_|Apr-06| .... and so on...
Weeks____1 2 3 4 1 2 3 4 1 2 3 4 5 1 2 3 4
Cels______x x x x x x x x x x x x x x x x x
Cels______x x x x x x x x x x x x x x x x x
Cels______x x x x x x x x x x x x x x x x x

Each "x" cel needs to know what month and week it is representing and determine whether or not it falls in between the start and end date.

Any ideas?