Displaying the same information every week in different cells and preserving data.
 

Each column displays data in a cell that was pulled from a pivot table
at the end of the week.(friday) I want to preserve the data in cell
B43 that I collect for mar.2,2007. On Mar. 9, 2007, the same data
will be pulled and placed in C43.
I have tried two different functions, but both do not preserve the
data.
Either nothing is displayed, or it is overwritten with the current
date's value.

=SUMIF(A1,"="&DATE(2007,3,2),Summary!E14) ...this one will overwrite
with the value I obtain from
Summary!E14 on Mar. 9. If I remove the sign, "0" is displayed after
3/2/2007.

=IF(TODAY()=DATE(2007,3,2),GETPIVOTDATA("mnemonic" ,Summary!$A
$2,"status","NOK"),"")...this one will not display anything for a date
after 3/2/2007

Any ideas?