I have a pull down menu (list) in cell B3 and when you select a student ID from this list it automatically puts today's date in cell A3 - A3 has the following formula =IF(B4,TODAY(),"") so it works great except that I need this date to be fixed once selected and what appears to be happening is the next day when you select another cell say B20 it changes all the previous dates back to the current date. So is there a way to make the previous dates remain static once selected?
Obviously the formula above should be cell B3 and not B4. I have attached my workbook also if that helps.
Just in column A - I sent you the workbook to look at - so there is no way to make the date permanent? At the end of the day is there a way to maintain the date value and remove the formula so that the next day the date is still there from the previous day?
Thanks I will use the shortcut keys.