Create rule using date-range to generate cell header
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.
Recent comments
6 years 3 weeks ago
6 years 41 weeks ago
7 years 6 days ago
7 years 3 weeks ago
7 years 4 weeks ago
7 years 10 weeks ago
7 years 18 weeks ago
7 years 18 weeks ago
7 years 18 weeks ago
7 years 18 weeks ago