» 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:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Financial Modeling - 2nd Edition
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Good to Great: Why Some Companies Make the Leap... and Others Don't
No comments have been submitted.
