Recording the value of a cell based on todays date

Hi everybody,

Here's what I am trying to accomplish but failed so far.

Say the summed value of a cell in A1 changes every day. In column c2 I have the date 1/1/2013, in c3 1/2/2013 ad so on, now what I want to do in d2,d3... is record and keep the value of A1 if today's date matches the value of c2, I am able to do that with a formula like this, but once the today's date changes the value of the previous cell returns "false". This is the formula I am using: =if(c1=today(),a1), meaning if the date in c1 matches today's date, show the sum in a1, but my problem is how to keep that value for that date unchanged and from turning to "false" once the today's date matches the date in the next cell, c3,c4,c5 and so on.


Thank you.

you can use a timestamp - and stop the circular reference
have a read here
http://www.howtoexcelatexcel.com/exc...with-formulas/
http://chandoo.org/wp/2009/01/08/tim...-formula-help/

you can just modify to use the formula =if(c1=today(),a1)