Date range in SUMPRODUCT

Hi all,

I am trying to sum figures within a specific date range in the following formulae.

=SUMPRODUCT(--(Bookings!G$7:G$576=B17),--(AND(Bookings!A$7:A$576>=$C$12,Bookings!A$7:A$576<$C$12+7)),Bookings!J$7:J$576)

Currently I get an error and I am certain it is in this part;

(AND(Bookings!A$7:A$576>=$C$12,Bookings!A$7:A$576<$C$12+7))

This is trying to look for dates that are greater than or equal to the one in $C$12 AND less than 7 days later.

Can anyone see why this will not work?

Thanks

Paul