» Creating Date and Time Stamp
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.
1. Go to Tools Options Calculation Tab Check the Iteration checkbox.
2. Use the IF and NOW functions as shown in the following formula:
3. Apply "mm/dd/yyyy hh:mm" format to column B.