This seems like it should be an easy formula, but I haven’t been able to crack it.
I want to create a formula that identifies a date and gives it a title.
IF({Date}>DATE(2021, 4, 1),“Q1”,“Q2”)
^^For example, I got this to work. Any date greater than April 1,2021 is noted as Q2.
BUT NOW I want to add in, AND any date less than June 30.