As long as the dates involved are all proper dates (not text) then:
=SUMPRODUCT(--($AA$10:$BE$10<=B6),$AA$12:$BE$12)


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119196