Newletter Spreadsheet Solution
 

A = Amount
B = Start Date
C = End Date

To produce Liability in Column D


=if ( today() < c1, a1*( c1 - today()) / (c1-b1), 0)

Thanks, JFC.

That's brilliant, exactly what we need. I might have to give you a call to help apply the equation but it looks simple.