Help

Re: Trouble With a Nested If/OR Date Formula

654 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Christopher_Can
6 - Interface Innovator
6 - Interface Innovator

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!

1 Reply 1
Christopher_Can
6 - Interface Innovator
6 - Interface Innovator

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!