» 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:
- A Mathematician Plays the Stock Market
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Not-for-Profit Accounting Made Easy
- Special Edition Using Microsoft Excel 2002
- Keys to Reading an Annual Report (Barron's Business Keys)
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
No comments have been submitted.
