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.