» Creating Date and Time Stamp
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
- Business Analysis with Microsoft Excel (2nd Edition)
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Yes, You Can Time the Market!
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
