If statement trying to get Q1 2018, Q2 2018, Q1 2019, etc

Okay, what I'm trying to do is come up with an IF statement (or if there's an easier way I'm open to that) to get the quarter and year of a date. So I want my IF statement to put out something like Q1 2018. Right now I have three columns - the 'date' and a column for the month derived from that date and a column for the year derived from that date.

My formula, which doesn't work, looks like this:

=IF(OR(B2="January"&C2=2018,B2="February"&C2=2018,B2="March"&C2=2018),"Q1 2018",IF(OR(B2="April"&C2=2018,B2="May"&C2=2018,B2="June"&C2=2018),"Q2 2018",IF(OR(B2="July"&C2=2018,B2="August"&C2=2018,B2="September"&C2=2018),"Q3 2018",IF(OR(B2="October"&C2=2018,B2="November"&C2=2018,B2="December"&C2=2018),"Q1 2018",""))))

I tried to do an if statement with an 'and' and an 'or' but that really didn't turn out well....

Any ideas?

.....

My formula was ten million characters and didn't work.

TMS's was a brilliantly short formula and totally works.

I gotta up my excel game.

Thanks TMS!

Knowing what to google is a good point. I try to use google as a resource, but sometimes I'm just not putting in the right words.