Conditionally format all the cells with dates of the current week-CodePudding

Home > Blockchain > Conditionally format all the cells with dates of the current week

Conditionally format all the cells with dates of the current week

Time：09-15

I have a table that looks like this:

some text    14.09.2022
some text    15.09.2022
some text    23.10.2022

And I need to conditionally format each cell in the second column if the date in that cell is during the current week.

I have tried different solutions from the Internet[^1], but neither works for me: each time Google Sheets says my formulas are wrong. Any help?

[^1]: For example, I have tried to adopt the formula found