problem copy paste cells with conditional formatting from 1 sheet to another

Hello,

I'm trying to copy/paste a sheet with a calendar and some cells that highlight dates on that calendar to another sheet.
The CF formula that highlights these cells is:

Formula:

=SUMPRODUCT((R4>=$A$5:$A$12)*(R4<=$B$5:$B$12))

cf2.jpg

If I copy that to the other sheet in a different row, then the highlighting doesn't work anymore so I altered the formula to:

Formula:

=SUMPRODUCT((R4>=$A5:$A12)*(R4<=$B5:$B12))

Then the first cells with start and end date are highlighted ok within a single month, but it doesn't highlight a date that goes from one month to the next.
cf2.jpg

I need multiple of these calendars with date-highlighting in 1 sheet, but I'm not sure what to do to make that work.

Any help would be greatly appreciated.

Thanks,

Michael.