add on date specfic

C

Curt

Am trying to have a amount added to a cell on a specific date (IE: 15) I want
it to add to the amount all ready in the cell.

=IF((M4=123),123)
This gives me 123 into ("C26") When the next ("!5") date comes up will this
add to the amount all ready there. If I try to chg dates in excel formula I
get FALSE. I tryed to chg dates to see if it would update no go. Can this be
done on worksheet or must it be done in VBA
Not sure what to try next.
Thanks
 
T

T. Valko

*If* you want to add the *same* amount for each 15th of the month this could
be done by counting how many 15th of the months have passed since a base date
then multiplying by the amount and it would continue to add the amount into
the future.

Is this something that might work for you?
 

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

function stumped 3
Cumulative formula for word table 0
How to use/create code in MS Word to calculate age? 0
Creating a Chart on form from selected data in query. 0
Conditional Formatting from a group 6
Merging from an Excel file with graphics 1
Summing Results Based On A Specific Date 2
Adding dates in a IF Statement 2

Top