» Determining Which Quarter a Specified Date Corresponds With
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Determining and indicating which quarter each of the dates listed in column A corresponds with.
Solution:
Use the CHOOSE, MATCH, and MONTH functions as shown in the following formula:
=CHOOSE(MATCH(MONTH(A2),{1,4,7,10}),"Quarter1","Quarter2","Quarter3","Quarter4")
Book Store:
Recommended Books:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- The Guide to Understanding Financial Statements
- Marketing Plan: A Handbook with Marketing Plan
- Excel Charts
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- The New Financial Order: Risk in the Twenty-First Century
No comments have been submitted.
