Hi,

How would I solve this?

I need to count any rows if they meet multiple criteria, but also the date field has to be greater than or equal to the 15th of the relevant month. E.g. Count if Column labeled contract type says "new build (cash)", and column labeled date of signature is >= 15th of July. Ideally July can 'move' as formula is pulled across each month.

Please help!

Capture.PNG