Forum Discussion

SWB_MTC's avatar
SWB_MTC
Copper Contributor
Feb 23, 2020
Solved

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

I'm using Office 365 and I have a column of dates that are sorted in ascending order (recent date on top).  In Conditional Formatting\Highlight Cell Rules\A Date Occurring section, there are three pr...
excel
Formulas and Functions
office 365
  • Patrick2788's avatar
    Patrick2788
    Feb 23, 2020

    SWB_MTC 

    conditional formatting rule:

    =WEEKNUM($A2)=WEEKNUM(TODAY())+X

     

    X=number of weeks

mathetes's avatar
mathetes
Silver Contributor
Feb 23, 2020

SWB_MTC 

 

If I were tackling this myself, I think I'd work out some "helper cells" or a "helper table" off in an obscure part of my workbook, where I'd first determine what range of dates falls in each of those weeks. One of those helper cells would be a simple "Y" for "2 weeks out" or "3 weeks out" etc.

 

And then refer to that cell (those cells) in the conditional formatting dialog box.

  • SWB_MTC's avatar
    SWB_MTC
    Copper Contributor
    Feb 25, 2020

    mathetesThank you so much for your suggestion. I was able to do it with a single formula (see above).

Resources