» 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:
- Microsoft Office XP Introductory Concepts and Techniques
- Microsoft Windows XP Inside Out
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Financial Peace: Revisited
- Dictionary of Finance and Investment Terms
No comments have been submitted.
