» Converting Older Dates to the Current Year
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Converting the dates listed in column A into the corresponding day and month of the current year.
Solution:
Use the DATE, YEAR, TODAY, MONTH, and DAY functions as shown in the following formula:
=DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))
Book Store:
Recommended Books:
- Windows XP All-in-One Desk Reference For Dummies
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Marketing Plan: A Handbook with Marketing Plan
- Writing Excel Macros with VBA, 2nd Edition
- Analyzing Markets, Products, and Marketing Plans
No comments have been submitted.
