Hi All,

This is my first thread, so please be gentle with me!

I am trying to create a spreadsheet that will populate a % of a resources time required between certain dates

For example, this is the data being provided:
Resource % start end
A 10 01/01/2009 01/03/2009
A 5 01/04/2009 01/07/2009
B 20 01/02/2009 01/06/2009

As an output, i need to get the data to be shown by resource and by month as a %

For example
Resource Jan Feb Mar Apr May Jun
A 0.1 0.1 0 0.1 0.1 0.1
B 0.1 0.1 0.1 0.1 0.1 0

Does anybody know if excel can perform this?
Currently I am working with formula's like:

=IF(a:a=a2,(=if(C2<="Feb"&D2>="feb",(B2/100),0)),0)

But it is returning #VALUE...

At a loss, and any help would be greatly appreciated, even if it is to say that Excel cant do this.

Cheers,
Dave