# I want to use a formula to convert a date into a year and quarter

i.e. if the date is 9/15/2020 I want to convert it to "Q3 2020"

• thank you

• Thanks so much to both of you. I have it working!

• Overachievers Alumni

@David Joyeuse that's a way easier formula! (Sadly, we're on a weird FY calendar - Oct-Dec = Q1)... but still thanks for sharing!

Kelly Drake (she/her/hers)

STARBUCKS COFFEE COMPANY| business optimization product manager

• This is a great solution and was just what I was looking for! Just one note - in order to report quarters it needs a very slight adjustment:

="Q" + ROUNDUP((MONTH([Date]@row)/3)) + " " + YEAR([Date]@row)

Dividing the Month by 4 will result in your year being divided into thirds of four months each rather than quarters of three months each.

• Actually, to find the Quarter with this, the roundup would be divided by 3, not 4. For example if December (12), was divided by 4 it would return 3, or Q-3, and July (7) would return Q-2. Dividing by 3 gives you the right Quarter (Q-4 and Q-3). Other than that, it is a very slick formula!

• For this formula :="Q" + ROUNDUP((MONTH([Date]@row)/3)) + " " + YEAR([Date]@row),what is Q what value does it the from the sheet?

I tried this formula but its returning an invalid operation error message.

Need some help with the logic.

Thanks

Ranjini Walter

• Hello,

I have tried both versions and I get an "UNPARSEABLE" error each time. Suggestions?

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!