# Quarter Formula

âś­âś­âś­âś­
edited 04/19/24

I am trying to create a formula that extrapolates the quarter (Q1, Q2, etc) based upon the end date column. Has anyone done this before?

Thanks in advance for any help provided.

## Best Answer

• âś­âś­âś­âś­âś­âś­
Answer âś“

I use this although I'm not sure if this works beyond the last year. I wrote it a while back.

= "Q" + ((ROUNDDOWN(((YEARDAY([End Date]@row) - 5) / 365) * 4)) + 1) + "-" + RIGHT([End Date]@row, 2)

## Answers

• âś­âś­âś­âś­âś­âś­
Answer âś“

I use this although I'm not sure if this works beyond the last year. I wrote it a while back.

= "Q" + ((ROUNDDOWN(((YEARDAY([End Date]@row) - 5) / 365) * 4)) + 1) + "-" + RIGHT([End Date]@row, 2)

• âś­âś­âś­âś­
edited 02/22/23

Thanks. I found an Excel formula that works.

="Q"+ROUNDUP(MONTH([Expected End Date]@row) / 3, 0) This formula works no matter the end year.

• âś­âś­
edited 12/31/23

Thanks a lot, Its also help me a lot.

• âś­

Many thanks! Your assistance has been incredibly beneficial.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!