» Converting Older Dates to the Current Year
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- East of Eden (Oprah's Book Club)
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Financial Risk Manager Handbook, Second Edition
- Absolute Beginner's Guide to Microsoft Excel 2002
No comments have been submitted.

