looking for a formula for excel

[tomasesp]

Hello

 

I created a google sheet that helps me keep track of my checking, savings, and credit card spending's. I already have down all the formulas that will subtract and add to my current balance anytime i input a value to the columns that hold that information. But I'm looking for a formula that will automatically input the value when its a specific date, for example a monthly subscription fee. I have look everywhere but can't seem to find an equation.

[Aros]

Try this stuff:

 

https://www.google.com/search?q=excel+add+value+every+month

 

http://stackoverflow.com/questions/3507922/sum-values-in-a-column-based-on-date

 

http://www.excelforum.com/excel-general/596404-add-constant-value-on-a-recurring-date.html

 

http://www.excelbanter.com/showthread.php?t=12797

[tomasesp]

Try this stuff:

 

https://www.google.com/search?q=excel+add+value+every+month

 

http://stackoverflow.com/questions/3507922/sum-values-in-a-column-based-on-date

 

http://www.excelforum.com/excel-general/596404-add-constant-value-on-a-recurring-date.html

 

http://www.excelbanter.com/showthread.php?t=12797

Thanks for the links but couldn't find the equation I'm looking for. the way i have it set up is that my A column is my dates, B = Reason, C = Withdraws, D = Deposits, E = balance. I'm looking for a formula that on a specific date of each month it will add the value to my withdraw column on that row of that day.     

[Misanthrope]

You need to use conditionals. =if(A="date-you-want", sum(get value,existing value),) leaving the second part of the conditional blank means do nothing. You can of course use an absolute or relative value for the date you want but since I'm assuming that's your pay check date.

[tomasesp]

You need to use conditionals. =if(A="date-you-want", sum(get value,existing value),) leaving the second part of the conditional blank means do nothing. You can of course use an absolute or relative value for the date you want but since I'm assuming that's your pay check date.

I tried it how you have it but every time i drag the formula down it just copies the value in each row. I'm trying to put that on the 17th of every month in my withdraw column it puts $21. 

[Misanthrope]

I tried it how you have it but every time i drag the formula down it just copies the value in each row. I'm trying to put that on the 17th of every month in my withdraw column it puts $21. 

 

You need to declare it as an absolute reference: put $ in front for each value that's absolute. For example $A$1

 

http://www.gcflearnfree.org/excel2013/15.2

[BOT Edward]

Do you have the full version of Excel (i.e. office)?

 

You could create a macro that will do this (using vba).