I am not quite followed on how your formulas work but I am guessing the
reason why values change often is J1=Today(). where every day it gets changed
then will change everything else.
why not eliminate Today() function altogether?
Let the user enter the date or create a button that will automatically fill
in today's date. a better approach is in workbook_open event, if the J1 is
empty then put in today's day value. not the formula.


"roverdisc1" wrote:

Here's the problem

-in cell E5- IF(E4<=J1,A1,0) -in cell F5- IF(F4<=J1,A1,0) and so on.

E4, F4 and so on, are fixed dates in two week intervals. J1 is TODAY().
When the calculation is made for E5, A1 will be a certain value. When the
calcualtion is made for F5, the value of A1 will be different. How can I
keep the result of E5 constant when the value of A1 changes?????

My brain is now toast and I can't figure it out. Any help would be
appreciated.