I need a formula to process "if the date in cell B2 is between the dates 10/1/2018-12/31/2018, then cell A2 will populate Q1. Additionally, cell A2 will turn a certain color since the data inside is Q1.
The issue that I am having is that I need this formula to encompass all dates within the calendar year and sort them based on quarters.
I've tried to find how to do "IF THEN" formulas, nested "IF THEN" formulas, and even conditional formatting, but nothing is able to encompass all the conditions I need.
Solved by S. W. in 27 mins