Jun 25 2024 11:31 AM
I have a project management calendar where I want to count the number of weeks per project scheduled after today:
I can find the week number for today: =WEEKNUM(TODAY(),2) Result: 26
And I can count the number of weeks after any given integer: =COUNTIF(G1:AF1,">=26") Result: 14
And I can count the number of scheduled weeks after a given integer: =COUNTIFS(G1:AF1, ">=26",G4:AF4,">0") Result: 2
But when I try to replace the integer in that formula with the formula for the week number, I get zero: =COUNTIFS(G1:AF1, ">=WEEKNUM(TODAY(),2)",G4:AF4,">0")
What am I missing here? Many thanks for any help.
Jun 25 2024 11:48 AM
SolutionJun 26 2024 03:44 AM
@dscheikey That did it! I learned something today - thank you!
Jun 25 2024 11:48 AM
SolutionPlease give it a try:
=COUNTIFS(G1:AF1, ">="&WEEKNUM(TODAY(),2),G4:AF4,">0")