Formula referring to dynamic table

[Paribartan]

Amt	Issue Date	Exp Date	Fee		Date From	Date To	Fee Rate
100000	09/01/2012	07/01/2013	=?		1/1/2012	11/01/2012	0.85%
200000	09/25/2012	10/25/2013			11/2/2012	=Today()	1.00%

<tbody>
</tbody>

Additional Remarks:
Windows 2007+MS Office Professional Plus 2010
Using dynamic table with lookups


Lets assume todays' date is 1/1/2013
Date format: mm/dd/yyyy

Amount and Exp date can change at any time. So as Fee Rate but fee rate change happen not so often.

Fee needed to be calculated quarterly.

At the moment I am doing it manually for all the data with additional changes in Amt & Expiry date with very long formula for example:
For quarter 01/10/2012-12/31/2012 for 200000 line of credit which has changed to 300000 on 10/10/2012

=20000*10 days*0.85%+300000*21 days*1.00%+300000*61 days*1.00%

How can I automatize the process of calculating fee which needs to be done every quarter with a single formula which will consider possible changes in Amount, expiry date and/or changes in fee%.


Thank you very much for your generous help.

Kind regards,
Paribartan