Forum Discussion

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
Feb 23, 2020
SWB_MTC
conditional formatting rule:
=WEEKNUM($A2)=WEEKNUM(TODAY())+X

X=number of weeks

Patrick2788

Silver Contributor

Feb 25, 2020

SWB_MTC

Most things are possible in Excel with some creativity. I'm surprised you were told no.

SWB_MTC

Copper Contributor

Feb 25, 2020

Patrick2788 Right?!? Me too! Especially now that you provided me the function name and I Googled it. There's info EVERYWHERE about it. I don't think it was me because I was extremely specific about what I needed, basing my description on the current allowable options (Last Week, This Week, Next Week). Maybe it was a language barrier thing.... Can't thank you enough though...You rock!