Saving data based on time(not with vba)

[isaacren]

Hello first time poster here, I have a bit of a head scratcher here. I am trying to save data based on a time stamp that it was entered. I know if I where to use VBA it would be a simple matter of creating an array and updating it at certain time stamps. However I would like to avoid using macros since the way I use this spreadsheet is highly custom and my co-workers most likely would mess with it.

Here is an example of what I have currently.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Saved Value[/TD]
[TD]Time Stamp[/TD]
[TD][/TD]
[TD]User imputed value [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2/9/2108[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2/10/2018[/TD]
[TD][/TD]
[TD]

---

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2/11/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2/12/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2/13/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2/14/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2/15/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
In the cell with the saved values I have this if statement running so far,

IF(TODAY()<=B3,IF(TODAY()>B2,D2,""),"")

However with this statement the cell will go blank after the day has past.

I guess my question is, is there any way to remember a value that was in a cell at a certain point?


I am using excel 2010 with no add ins at the moment.

Thanks.

 

[isaacren]

Actually figured this one out myself.

The error in my formula was that i was making it go blank if false. What I needed to do was to reference itself.

Here is the formula that works

IF(TODAY()<=B3,IF(TODAY()>B2,D2,""),A2)

This only works if you have iterations on and maximum of 1.