» 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:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Adventure Capitalist: The Ultimate Road Trip
- Retire Young, Retire Rich
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Financial Risk Manager Handbook, Second Edition
- Marketing Plans
No comments have been submitted.
