Need help with a formula for the following Quarter.

[TRBS]

If my event is September 2, 2025 (aka "program start date"), it would be in Quarter 3, 2025. But I need to list that commission would be paid the following quarter (aka "quarter earned", so Q4, 2025. Fiscal year runs Jan - Dec like the calendar.

I currently have the formula (see below), but its marking everything in FY 2024. instead of in the appropriate next quarter. I know I am missing a small tweak, but cannot figure it out!

'Q' &

IF(

ROUNDUP(MONTH({Program Start Date})/3, 0) = 5,

1,

ROUNDUP(MONTH({Program Start Date})/3, 0)

) &

" - FY" &

IF(

ROUNDUP(MONTH({Program Start Date})/3, 0) = 5,

25,

24)

[TheTimeSavingCo]

EDITED:  Ha just use @Alexey_Gusev's formula in the next post instead, it's much cleaner!

Does this look right? 

'Q' & 
DATETIME_FORMAT(
  DATEADD(
    {Program Start Date},
    1,
    'quarter'
  ),
  'Q'
) &
" - FY" &
DATETIME_FORMAT(
  DATEADD(
    {Program Start Date},
    1,
    'quarter'
  ),
  'YY'
)

[Alexey_Gusev]

Hi,
A "D.R.Y." version of formula: 😁