» 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:
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Financial Statement Analysis with S&P insert card
- Excel Charts
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Keys to Reading an Annual Report (Barron's Business Keys)
No comments have been submitted.
