Converstion of Date into Quarter & Year

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?

Tags:

Answers

  • Carson Penticuff
    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
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!