Forum Discussion

austinugonzalez's avatar
austinugonzalez
Copper Contributor
Jan 24, 2023
Solved

COUNTIF sort by date?

Good morning, I am trying to keep track of tax clients by category. When a new client is added, the type of client populates in a single column which is updated weekly. I have the function set to ke...
  • SergeiBaklan's avatar
    Jan 24, 2023

    austinugonzalez 

    That could be like

    =COUNTIFS(..., date, ">=" & TODAY()-WEEKDAY(TODAY(),2)+1  )

    if start counting from the start of this week and your week starts from Monday.

Resources