Finding current week and if any item has somthing due

I have a worksheet with almsot 40 items and everyday of the year, but i need
something to tell me quickly if there is something coming up this week. I can
do this for each day and column, but i am having trouble getting a formula i
can use to look at all the items, and count up all the items due that week.

This is what i have so far, the inital criteria "1" tells me there is
something due, the other is to see if it is the current week;

=COUNTIF(D16,1 & (IF(WEEKNUM(E16,2)=WEEKNUM(TODAY(),2),,1)))

Would this help

=SUMPRODUCT(--(WEEKNUM(D16,2)=WEEKNUM(TODAY(),2)*(--($E$16:$E$100=1)*(--($E$16:$E$100)))))

VBA Noob

Not quite becuase i need to look over all the dates, not just one of them, i
think i figured it out though:
(This is also looking off other sheets, not specified in original question)

=SUMPRODUCT(ISNUMBER(SEARCH(WEEKNUM(TODAY(),2),'Target Closed
Date'!$C$3:$C$368))*('Target Closed Date'!$G$3:$AS$368=1))

and if you need it for the next week just add +1 after "TODAY(),2)" like this:

=SUMPRODUCT(ISNUMBER(SEARCH(WEEKNUM(TODAY(),2)+1,'Target Closed
Date'!$C$3:$C$368))*('Target Closed Date'!$G$3:$AS$368=1))

Thank you for your help though, bringing up SUMPRODUCT made everything click
: )

"VBA Noob" wrote:

>
> Would this help
>
> =SUMPRODUCT(--(WEEKNUM(D16,2)=WEEKNUM(TODAY(),2)*(--($E$16:$E$100=1)*(--($E$16:$E$100)))))
>
> VBA Noob
>
>
> --
> VBA Noob
> ------------------------------------------------------------------------
> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
> View this thread: http://www.excelforum.com/showthread...hreadid=562800
>
>