Tip Printed from ExcelTip.com

---

Determining Which Quarter a Specified Date Corresponds With


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")