Is it 17-22 years or days?
When days, then (2 conditional formats, let's assume the date you are checking is in column A, the 1st data row is 2):
Select the range you want the conditional formats apply to (a single column in your table, several columns, or the whole table - minus header(s)).
Open Conditional formatting, apply 2 condition formulas and according formats.
1. =AND(($A2-17)>=TODAY();($A2-22)<=TODAY())
2. =AND(($A2+30)>=TODAY();($A2)<=TODAY())
|