Formula referring to dynamic table

[Paribartan]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Amt[/TD]
[TD]Issue Date[/TD]
[TD]Exp Date[/TD]
[TD]Fee[/TD]
[TD][/TD]
[TD]Date From[/TD]
[TD]Date To[/TD]
[TD]Fee Rate[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100000[/TD]
[TD]09/01/2012[/TD]
[TD]07/01/2013[/TD]
[TD]=?[/TD]
[TD][/TD]
[TD]1/1/2012[/TD]
[TD]11/01/2012[/TD]
[TD]0.85%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]200000[/TD]
[TD]09/25/2012[/TD]
[TD]10/25/2013[/TD]
[TD][/TD]
[TD][/TD]
[TD]11/2/2012[/TD]
[TD]=Today()[/TD]
[TD]1.00%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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