I have a problem with a formula. The formula is below.

=IF(AND('Summary Totals'!$D$46-'Summary
Totals'!$D$510,TODAY()=H30),'Summary Totals'!$D$46-'Summary Totals'!$D$51,0)

The problem is this, when it goes in and it matches today's date it does the
various calculation and stores the results in the cell. However, I need to
retain this information as it represents a snapshot of information on that
date. When it next goes into the application the following day the previous
day's information is overwritten with '0' for zero. Obviously this is no
good. If you have any suggestions on how to retain the information by
modifying the formula I would greatly appreciate it.


--
Mike P