Conditionally Format Dates based on Different Criteria (>30, >60, >90...etc.)
For example, we have set of due dates and we would like to highlight dates more which are older than 30 days, 60 days, or 90 days. Follow...
Highlight Dates older than 6 Months
If you want to highlight dates older than 6 months, you can use any of the two formulas to do that =DATEDIF(A2,TODAY(),"m")>=6...
