» 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:
- Advanced modelling in finance using Excel and VBA
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- How to Pay Zero Taxes (Annual)
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Business Plans Kit for Dummies (With CD-ROM)
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
No comments have been submitted.
