One way:

A1: <base
A2: <fee
A3: <date

A5: =A1 + INT((TODAY()-A3)/30) * A2


In article ,
"Mark_N_Jen" wrote:

For auction site accounting - I need a formula that will add recurring fees
to a particular field every 30 days based on a date in another field.