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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
One way:

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

A5: =A1 + INT((TODAY()-A3)/30) * A2
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Excel formula to incrementally increase a value by 1 every 365 day 2
Excel Formula - Count Dates from another Sheet 8
Trailing 30 days sum calculation with excel 1
Need Formula 1
Attendance tracker last 30 days 1
Exclude weekends when counting days only on day 29 or 30 3
Conditional Formatting or IF function 3

Back
Top