need help calculating revenue over period of time
 

Hi all, here is what I am trying to do with the data below: I would
like to take the revenue received from the closed contract and spread
it out over the length of the contract, dividing it up by the fiscal
quarters. I have tried numerous ways to do this but cannot seem to
find the right array. I can do this with if/then statements but they
of course cannot search a range. Any help would be greatly
appreaciated!

I can email an excel document if it makes it easier...

Client Name Revenue from contract Quarter Contract date Length in
months Rev per quarter
Client 1 22,000,000 Q407 39172 12 5500000
Client 1 44,000,000 Q108 39173 36 3666666.667
Client 1 11,000,000 Q407 39142 24 1375000
Client 2 100,000,000 Q208 39326 60 5000000
Client 2 200,000,000 Q108 39203 60 10000000
Client 2 300,000,000 Q407 39139 60 15000000
Client 3 1,000,000 Q208 39270 12 250000
Client 3 2,000,000 Q308 39356 6 1000000
Client 3 3,000,000 Q408 39478 24 375000

Client 1
Terms Q3FY07 Q4FY07 Q1FY08 Q2FY08 Q3FY08 Q4FY08
12
24
36
48
60
72