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.

Saved Value	Time Stamp		User imputed value
	2/9/2108
	2/10/2018
	2/11/2018
	2/12/2018
	2/13/2018
	2/14/2018
	2/15/2018

<tbody>
</tbody>

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.