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

Z

ZZ430

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

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
 
Z

ZZ430

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