I'm working with a table separated per month on each sheet. There is a column for date and I would like to conditionally format every other week to easily identify them.

The catch: our working week is not Sunday - Saturday, it is Thursday - Wednesday.

How would this be possible?

I've search and found a formula for every other row, but would like every 7 rows based on Thursday - Wednesday. ( =MOD(ROW(),2)=1 )