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

[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.

 

[JE McGimpsey]

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

 

[Guest]

That certainly appears to be working...THANKS.

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