Cell A1 is equal to cell A4.
Cells A4 thru A100 contains consecutive ascenting dates.

Each day I select Row 4 and delete that row.

My problem is that I get the #REF! error in cell A1 even though Row 4
is replaced by Row 5's data. How can I always preserve the A1 and A4
equivalency whenever I delete Row 4. This means that cell A1 has the
date that was originally in cell A5 (and is now in Row 4 when the
former Row 4 was deleted).