Excel Help: IF/Today formula problem?

-I'm trying to create a spreadsheet where I can track dates in which data was added in.



For example: If I add data in cell B1, I want A1 to display the date that B1 had data entered. The thing is that I don't want the date to change after that point. I don't want to open up excel and have all the dates automatically change to today's date; I want them to stay the original date they where when B1, B2, B3... was entered.



Can anyone help me figure out the IF statement to this? Thanks!It looks like Excel time functions including Today, Now, Time are all volatile meaning the values will change every time the sheet calculates. From what I could find you either enter the timestamp manually, need to create and allow a circular reference, or do this with VBA.



to enter time in a cell using shortcut = CTRL+SHIFT+;



http://chandoo.org/wp/2009/01/08/timesta鈥?/a>

http://www.teachexcel.com/excel-help/exc鈥?/a>