» 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:
- PowerPoint® 2002 For Dummies®
- Absolute Beginner's Guide to Microsoft Excel 2002
- The 11 Immutable Laws of Internet Branding
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Wall Street Journal Guide to Understanding Money and Investing
- Marketing Planning for Services
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
