=SUMPRODUCT(--($B$5:$AF$5=$AL$3-WEEKDAY($AL$3,2)+1),--($B$5:$AF$5<=$AL$3),$
B6:$AF6)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"edwardpestian"
wrote in message
news:edwardpestian.2bepbs_1153671908.5181@excelfor um-nospam.com...

Oops...not exactly working. When I select a date within the middle of
the week, Wednesday 07/12 for example, the formula returns the W-T-D
for that entire week. I need it to return the W-T-D only for the
previous Monday (07/09) through 07/12 as opposed to 07/16.

Any ideas?

-ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=564100