» Creating Date and Time Stamp
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Windows XP for Dummies
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Investing for Dummies, Third Edition
- Microsoft Office XP Introductory Concepts and Techniques
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
No comments have been submitted.
