Quarter Formula

Felicia Nabors · 02/22/23

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.

Lucas Rayala · 02/22/23

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)

Lucas Rayala · 02/22/23

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)

Felicia Nabors · 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.

KateWinslet · 12/31/23

Thanks a lot, Its also help me a lot.

salmawisoky · 02/02/24

Thanks.

aroonwilley · 02/23/24

Many thanks! Your assistance has been incredibly beneficial.

Best Answer