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.