Date Fomat to Fiscal Year and Quarter

[maxiemens]

Hi together,

do you know how can I get for e.g. this date: 2021-02-01 to this format: FY22/23 - Q4 ('FY' YY/YY+1 - 'Q'Q)

I should use the formula tool, but how can I do it?

The Fiscal year starts at 1st of october.

Thanks in advance,

Max 

[DavidP · Accepted solution]

Hi @maxiemens,

Have a look if this works

[RobertOdera]

Hi, @maxiemens 

Sorry, I'm just coming back from the Holiday this week, and I will not likely post much until Friday.

Still, what @DavidP  proposes is a great way to code your Fiscal year breaks and Period names!

Kindly try David's approach and accept it as a solution + like, if it works for you.

Else, I will watch out for your additional comments and revert starting this Friday.

Cheers!

[maxiemens]

@DavidP thanks that works fine.

Big thanks 🙂