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

*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?


--
Biff
Microsoft Excel MVP


"Curt" wrote:

> 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