I don't feel like setting up a spreadsheet to test this so I'll tell you how to do it and you can figure it out from my verbal description. It sounds like a combination of TEXT() to separate the date into DD-MM format and SUMPRODUCT or an array formula should do the trick for you.