Skip to main content

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!


Reply