» 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:
- Microsoft Windows XP Step by Step (With CD-ROM)
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
No comments have been submitted.
