Counting the Number of Open Projects In a Week

[BC_Diver]

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")

Or in English: return the total number of projects that are open in a specific week to populate a pivot table. 

It seems super easy but I cant seem to figure out how to do a sum/total with an AND argument plus YYWW isn't a supported data format from what I can tell.

[#2]

Hi @BC_Diver , could you please send a sample of your file? (you can populate it with fake data)

With this, will be easier to we find a solution together.