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

Lucas Rayala

Feb 22, 2023

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)

Thanks a lot, Its also help me a lot.

salmawisoky · 02/02/24

Lucas Rayala

Feb 22, 2023

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)

Thanks.

aroonwilley · 02/23/24

Felicia Nabors

Feb 22, 2023

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.

Many thanks! Your assistance has been incredibly beneficial.

Unknown · 03/18/24

This content has been removed.

Unknown · 05/07/24

This content has been removed.

Unknown · 05/16/24

This content has been removed.

Formulas and Functions

Formulas and Functions

Quarter Formula

Best Answer

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Formula - use % complete to determine whether in progress

Formula error

TRYING TO FIND THE ERROR IN THIS FORMULA