I have a workbook with with the following data:

Date Premium Paid, Premium Paid Amount, Days in Force (in a column numbered
from 1 - 365), % of Retained Premium (one column to the right - a value for
each day 1-365)

I would like to make a report to show the balance of the premium that is at
risk. I would like to pick up the Date the Premium was Paid and subtract
today's date. I would like the result to match the number in the column of
days from 1-365 and pick up the corresponding % of Retained Premium. Then, I
would like to take the result and subtract it from 100 to get the % of
Premium at risk. Then I would like to take the result and multiply it by the
Premium Paid Amount. This should give me the result I would like.

Any help would be appreciated.