delayed calculation

[Don]

Hi Again,

Second thought on this....Probably only need one cell with
the "Today" function in it. Then test it with the
following:

=IF(OR(A1=37987,A1=38078,A1=38169,A1=38261),"Your
Formula",""))

Have a good day,

Don

-----Original Message-----
hello,
In my workshhet I have 7 columns. fist is deposite, 2nd

is rate%, 3rd, 4th and 6th are the quarterly payment i
have to make, 7th is the balnce. the formula for the
quarterly payment is (a*b) and for the balance is (a-
(a*b)).

Now the problem is when I put the formula for quarterly

payment column all the quarterly payment are calculted
and deducted long before the begening of the quarter.

What I am looking for is a formula which calculates

quarterly payment only at the begening of the quarter not
before ( for eg, quarterly payment for 4th quarter should
be calculated only on 1st of Oct not before)

Is this possible without using VB. If has to be used

please be kind enough to give one example. I am using
excel 2003.