Excel formula to match date calculation?

Rates
02-Jun-09 19-Jul-09 1.222
20-Jul-09 18-Aug-09 1.245
19-Aug-09 30-Nov-09 1.340
01-Dec-09 31-Dec-09 1.367

Amount
02-Jun-09 18-Jun-09 35000
19-Jun-09 23-Aug-09 25000
24-Aug-09 31-Dec-09 5000

Result
Jun = (35000 * 1.222) + (25000 * 12/66days * 1.222)
Jul = (25000 * 31/66days * 19/31days * 1.222) + (25000 * 31/66days * 12/31days * 1.245)

Is it possible to formula this part?