» Converting a Date into a String, Indicating the Quarter Number and Year
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Converting the dates listed in column A into strings indicating the relevant quarter number and year, using the following format:
"Quarter X, YYYY".
Solution:
Use the MONTH, INT, and YEAR functions as shown in the following formula:
="Quarter " &INT((MONTH(A2)+2)/3)&", "&YEAR(A2)
Book Store:
Recommended Books:
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- The 22 Immutable Laws of Branding
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Microsoft Office XP Introductory Concepts and Techniques
No comments have been submitted.
