Apr 06 2023
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.
Apr 07 2023
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.