You can do it with SUMPRODUCT.

Assuming A1:A10 is dates and B1:B10 are the records:

=SUMPRODUCT((DAY(A1:A10)=1)*(B1:B10))


Edit: Same solution and ranges! Creepy!