» 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:
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Learn MS Excel 2002 VBA/XML Programming
- Microsoft Word Version 2002 Inside Out
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
