How can I have a cell show the value of another cell only during a 1 month window?

[Anov229]

Here’s the beginning of my formula: =IF(SUM(E44:E51)>0, “”,)

For the “otherwise” portion I want it to show the value that a cell in another sheet had during a date window and hold that value even if the cell from the other sheet changes in value, is this possible?

I may not be clear here so I’ll explain again in a different way. If the cell in sheet1J84 currently reads 25 on May 10, 2016 then I want the cell Sheet2E43 to read 25 as well, If cell Sheet1J84 is changed to 30 on May 21, 2016 then I want Sheet2E43 to change to 30, but if Sheet1J84 is changed to 10 on say June 3, 2016 (or any day after May 31) I still want cell Sheet2E43 to read 25 and never change again.

Is there anyway of making this happen?

[Lupp]

Spreadsheets are not history aware. Thus what you want cannot be done without a severe violation of the basics. If you dedicate, adjacent to sheet1.J84 e.g., as many cells as needed to contain dates of editing and previous values, You have to ensure that they are used in the correct way. Again violating the spreadsheet paradigm you may, however, do this relying on a “macro” assigned to the appropriate sheet event. You should try to avoid these complications.