» Converting a Date into a String, Indicating the Quarter Number and Year
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Analyzing Markets, Products, and Marketing Plans
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The Interpretation of Financial Statements
No comments have been submitted.
