ExcelBanter - I need an Excell formula that will add x$'s every 30 days

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I need an Excell formula that will add x$'s every 30 days (https://www.excelbanter.com/excel-worksheet-functions/32184-i-need-excell-formula-will-add-x%24s-every-30-days.html)

Mark_N_Jen

I need an Excell formula that will add x$'s every 30 days

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.

JE McGimpsey

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.

All times are GMT +1. The time now is 12:55 PM.