Hi,

Is there a way to create a rule using a date-range to result in a cell being labeled something in particular?

For example, if TODAY() is between 4/1/2017 and 6/30/2017, the cell will say "Quarter 4",
whereas if today's date is between 7/1/2017 and 9/30/2017, that cell will instead say "Quarter 1".

Thank you.