Converstion of Date into Quarter & Year

Willie Baez

Hello,

I'd like to convert a date into a quarter as the following example illustrates: If the date is 07/10/2023, how do I get this converted into Q3 - 2023 in a new column I've created?

Carson Penticuff

This should work as long as your date column is correctly formatted as a date. Just replace [Date Column] with your column name.

="Q" + IF(MONTH([Date Column]@row) >= 10, "4 - ", IF(MONTH([Date Column]@row) >= 7, "3 - ", IF(MONTH([Date Column]@row) >= 4, "2 - ", "1 - "))) + YEAR([Date Column]@row)

Peggy Parchert

Hello Willie,

Not sure how your sheet is setup but you could put the below formula in a Qtr/Year column:

=IFERROR("Q" + IF(MONTH(Date@row) = 1, "1" + "/" + YEAR(Date@row), IF(MONTH(Date@row) = 2, "1" + "/" + YEAR(Date@row), IF(MONTH(Date@row) = 3, "1" + "/" + YEAR(Date@row), IF(MONTH(Date@row) = 4, "2" + "/" + YEAR(Date@row), IF(MONTH(Date@row) = 5, "2" + "/" + YEAR(Date@row), IF(MONTH(Date@row) = 6, "2" + "/" + YEAR(Date@row), IF(MONTH(Date@row) = 7, "3" + "/" + YEAR(Date@row), IF(MONTH(Date@row) = 8, "3" + "/" + YEAR(Date@row), IF(MONTH(Date@row) = 9, "3" + "/" + YEAR(Date@row), IF(MONTH(Date@row) = 10, "4" + "/" + YEAR(Date@row), IF(MONTH(Date@row) = 11, "4" + "/" + YEAR(Date@row), IF(MONTH(Date@row) = 12, "4" + "/" + YEAR(Date@row))))))))))))), "")

Hope it helps.

Peggy