Tip Printed from ExcelTip.com

---

Creating Date and Time Stamp


Problem:

Creating a timestamp for each of the values in List1 (column A).
We want the timestamp to display the date and time that each value was entered or when it was most recently modified.

Solution:

1. Go to Tools  Options  Calculation Tab  Check the Iteration checkbox.
2. Use the IF and NOW functions as shown in the following formula:
=IF(A2=",",IF(B2="",NOW(),B2))
3. Apply "mm/dd/yyyy hh:mm" format to column B.