Forum Discussion

ReadTheIron's avatar
ReadTheIron
Copper Contributor
Jun 25, 2024
Solved

Counting weeks after today

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...
excel
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Jun 25, 2024

    ReadTheIron 

    Please give it a try:

    =COUNTIFS(G1:AF1, ">="&WEEKNUM(TODAY(),2),G4:AF4,">0")

     

dscheikey's avatar
dscheikey
Bronze Contributor
Jun 25, 2024

ReadTheIron 

Please give it a try:

=COUNTIFS(G1:AF1, ">="&WEEKNUM(TODAY(),2),G4:AF4,">0")

 

  • ReadTheIron's avatar
    ReadTheIron
    Copper Contributor
    Jun 26, 2024

    dscheikey That did it! I learned something today - thank you! :smile:

Resources