=LEFT($O2,LEN($O2)-FIND("-", $O2))*1=WEEKNUM(TODAY()*1)
(this formula returns FALSE if entered in a cell, but does not work in conditional format dialog box.)
Cell O2 Contains date values entered as: 03/30/2022-05/25/2022
if the first date is in current week I want to highlight the cell with yellow.
any help would be appreciated!
(this formula returns FALSE if entered in a cell, but does not work in conditional format dialog box.)
Cell O2 Contains date values entered as: 03/30/2022-05/25/2022
if the first date is in current week I want to highlight the cell with yellow.
any help would be appreciated!