Trouble With a Nested If/OR Date Formula

I’m sure I’m missing something simple here, but I’m trying to make formula that outputs the correct Quarter and then Year based on a relevant date field. So like Q1 - 2020

What I’ve come up with so far isn’t working, possibly because I’m missing something or have been a bit too confused by the nested IFs

IF(OR(Month({Date Start})=1, Month({Date Start})=2, Month({Date Start})=3), “Q1”,

IF(OR(Month({Date Start})=4, Month({Date Start})=5, Month({Date Start})=6), “Q2”,

IF(OR(Month({Date Start})=7, Month({Date Start})=8, Month({Date Start})=9), “Q3”,

IF(OR(Month({Date Start})=10, Month({Date Start})=11, Month({Date Start})=12), “Q4”," "))))

&

" - "

&

Year({Date Start})

Any guidance is appreciated!

Figured this one out:

IF({Date Start}=BLANK(),"",DATETIME_FORMAT({Date Start},‘Q’)&"Q | "&YEAR({Date Start}))

Did not realize the DATETIME_FORMAT formula had a quarterly output option!

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