Hello
See my attached reply. One way uses an helper column with SUMPRODUCT, the other is an ARRAY formula without a helper column. Whichever is most efficient for your needs. I can't think of another way at the moment.
However, I get your example to = 12, as the 06/04/12 was a Friday (Good Friday) Bank Holiday in the UK, not a Monday and Tuesday as you stated.
Hope this helps.
DBY
Bookmarks