Function available for changing dates to a quarter output ?

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





Please sign in to leave a comment.