Counting the Number of Open Projects In a Week

I need help generating a formula and really wish Excel would support Week numbers better. Anyway here's what I'm trying to do: countif ("closed YYWW" = 0) && ("created YYWW" >= "current YYWW")   O...