Hi all,

I would like to ask for some help regarding a close date which is right now the format "May 31, 2024". I want to use the month April, May, and June to define a text output based on the month.

For example: 

Close Date column --> Quarter column

April 23, 2024 --> Q4 (best case also the year) = Q4 2024

July 2, 2024 --> Q1 = Q1 2025

This is our fiscal year and as Klipfolio is not having FY setups I would like to calculate them directly. 

Any ideas ?

Thx for your help

Ralf