Quarter calculation based on timeline end month

Hi,
Need your help with creating an easy formula that return the quarter from the time line column.
for example:
timeline = 1 OCT 2021 until 31 OCT 2021 >>> Q column = Q4-2021
timeline = 1 OCT 2021 until 31 FEB 2022 >>> Q column = Q2-2022

@naamal

Here you go:

IF({Timeline#End},"Q"&FORMAT_DATE({Timeline#End},"Q-Y"),"")

Jim - The Monday Man channel
Signup for a FREE Integromat account with this link and get a FREE hour with The Monday Man

1 Like

Its great!! Thank you!

image001.png

It’s great!!! thank you!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.