Tip Printed from ExcelTip.com

---

Converting a Date into a String, Indicating the Quarter Number and Year


Problem:

Converting the dates listed in column A into strings indicating the relevant quarter number and year, using the following format:
"Quarter X, YYYY".

Solution:

Use the MONTH, INT, and YEAR functions as shown in the following formula:
="Quarter " &INT((MONTH(A2)+2)/3)&", "&YEAR(A2)