Save a Permanent Record of Previous values

I have a spreadsheet where the values change daily. I would like the values permanently recorded and saved automatically in a list showing what the value was and on what day. I tried using if-then-else and datevalue but when the date changes to the next day it just picks up the new value instead of retaining the original one. ???

Thanks for the reply. I may not have been perfectly clear about what I'm trying to do. My spreadsheet picks up the data from another source which shows in a particular cell. This can be different every day. So, what I would like is for the data from day one in one cell (A1) and for day two in the cell below it(A2), day three below that(A3) and so on. I can get A1 to record the data(value) for that day and A2 to record the data for day two and so on, however, the problem is when it records day two it not only puts its value in A2 but it also changes A1 to day two's value and on day three when it puts its value in A3 it changes both A2 and A1 to the day three value. I want the value for day one to remain the same as it was originally entered and the same for for day two and so on, so I can have an historical record of what the values were for each of these days.