Forum Discussion

BC_Diver's avatar
BC_Diver
Copper Contributor
Apr 06, 2023

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

 

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.

Excel
Formulas and Functions
  • rzaneti's avatar
    rzaneti
    Iron Contributor
    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. 

Resources