Starting Q1 on November

[wholelottared]

Hi I'm trying to start Quarter 1 on November via this formula

'Q'&If(Month(QuarterStart((COB_Date2)))='1',4,Div(Month(QuarterStart((COB_Date2))),3))

but it starts Q1 on May instead. How can I get Q1 to start on November while still retaining all Q1-Q4 for the year. I'm loading an inline table by the way. Thanks!

Full ex.

Table2:

LOAD *,

'Q'&If(Month(QuarterStart((COB_Date2)))='1',4,Div(Month(QuarterStart((COB_Date2))),3))

Inline [

COB_Date2, Sales

01/01/2018, 20

02/01/2018, 30

05/01/2018, 68

08/01/2018, 25

10/01/2018, 65

];

[IamAlbinAntony · Accepted solution]

Use this,

'Q' & ceil(month(AddMonths(Date(COB_Date2),-8))/3)

 

[wholelottared]

Excellent. This helped out so much. Thank you!!