I have a spreadsheet with two dates entered into a single cell separated by a "-" as follows:
11/17/2022-05/11/2023
I have tried multiple times to figure out a way to highlight the cell if TODAY() is within the two dates range:
I can use the LEFT or RIGHT to conditional format, but somehow I can't get the 'between' to work.
I know I must be missing something simple, but I'm not seeing it.
any help would be appreciated.
11/17/2022-05/11/2023
I have tried multiple times to figure out a way to highlight the cell if TODAY() is within the two dates range:
Code:
=AND(WEEKNUM(LEFT($O2,LEN($O2)-FIND("-",$O2)))*1>=TODAY(),WEEKNUM(RIGHT($O2,LEN($O2)-FIND("-",$O2)))*1<=TODAY())
I can use the LEFT or RIGHT to conditional format, but somehow I can't get the 'between' to work.
I know I must be missing something simple, but I'm not seeing it.
any help would be appreciated.