Say we want to add 123 each time we pass the 15th of the month.
Let's us a small table, A1 thru A12
In A1 enter:
=IF(TODAY()DATE(2009,ROW(),15),123,0) and copy down thru A12
Today we see:
123
123
0
0
0
0
0
0
0
0
0
0
we get 123 for January and February, but not yet March because today is
before the 15th.

In anoth cell enter:
=SUM(A1:A12) This is the value you need.
--
Gary''s Student - gsnu200836


"Curt" wrote:

Want to have on a given date add an amount to a cell. When I use date to get
amount. After date changes amount in given cell goes away.
=IF((L4=2),123) puts 123 into m4 only on day then its gone.
L4 is day of date
Final is to have 123 added into another cell on date each month this is a
monthly expendure.