Retain Value After Date Changes

Hi,

I have the sales figures which are updated daily in Sheet 1. This figures in Sheet 1 are updated daily and once we cross over to the next day, it overrides the figures from previous day to the current date.

In Sheet 2, I am trying to sum the sales figures automatically from Sheet 1 for every day. The formula should retain the values when we cross over to the next day and so forth.

Is there a way to build a formula to accomplish this ? Appreciate all the help.

I have a similar cross post here:

https://www.mrexcel.com/board/thread...value.1235119/