» Determining Which Quarter a Specified Date Corresponds With
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- Investing for Dummies, Third Edition
- Mortgages For Dummies®
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Guide to Financial Reporting and Analysis
- Analyzing Markets, Products, and Marketing Plans
No comments have been submitted.
