Conditional Formatting for Date Occurring 2 Weeks (not days) in the Future

Patrick2788  Thanks again!  So on a hunch, I checked out the order of my formulas.  I had added Week 4's formula *prior* to Week 3's formula which made Week 3 the last in the list and forgot to reorder them in correct order (Week 1, Week 2, Week 3, Week 4).  After I reordered the formulas, it worked like a charm, so apparently the order makes a difference. Thank you so much!!! It makes me sad that when one contacts the sanctioned Microsoft Excel Support Experts for a paid account via the Chat Tool, you're told it can't be done. I *knew* it had to be possible as I couldn't have been the only person on the planet that needed to see dates in the future in relation to how many weeks out they are.  Much respect to you @Patrick2788!