| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I add a value to a cell every 30 days?
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. |
|
#2
|
|||
|
|||
|
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 In article , "ZZ430" wrote: 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. |
|
#3
|
|||
|
|||
|
That certainly appears to be working...THANKS.
"JE McGimpsey" wrote: 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 In article , "ZZ430" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Hybrid Mode
