How do I add a value to a cell every 30 days?

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

Guest

I'm trying to create a calculator using Excel where in I add a given value to
a cell every month. This is not a financial equation.
 
One way:

assume you want to add 10 every month, starting one month from today:

=DATEDIF("2/11/2005",TODAY(),"m") * 10

or, every 30 days:

=INT((TODAY()-DATE(2005,2,11))/30)*10
 
That certainly appears to be working...THANKS.

JE McGimpsey said:
One way:

assume you want to add 10 every month, starting one month from today:

=DATEDIF("2/11/2005",TODAY(),"m") * 10

or, every 30 days:

=INT((TODAY()-DATE(2005,2,11))/30)*10
Click to expand...
 

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

Trailing 30 days sum calculation with excel 1
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Adding every sixth value 8
how do I add time worked over days/wks/mon greater than 24 hours 3
I want the autofill/drag function to skip empty cells 1
Cross refrence an index table and sum in one step? 7
I can't copy and paste equations 0
Days Calculation 11

Back
Top