I have project resourcing data in XL the form:
Person | Project | StartDate | EndDate | Percentage

Is it possible to use a pivot table to display this as:
Person in column 1
Month (Jan, Feb, Mar, ...) across the columns
Sum of Percentage for each month that falls within the start/end date

eg. XL data
Person | Project | StartDate | EndDate | Percentage
Andrew | Proj1 | 1/1/2011 | 28/2/2011 | 50%
Andrew | Proj2 | 1/2/2011 | 28/2/2011 | 30%
Adam | Proj1 | 1/2/2011 | 28/2/2011 | 90%

To be displayed in pivot table as:
Person | Jan | Feb | Mar | ...
Andrew | 50% | 80% | 0%
Adam | 0% | 90% | 0%

I know I can build start and end date into a formula but I don't know
how to create the month columns and without those there is no month
entry to compare start/end date against.

Thanks very much for any help.
Andrew