Forum Discussion
austinugonzalez
Jan 24, 2023Copper Contributor
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...
- Jan 24, 2023
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.
austinugonzalez
Jan 24, 2023Copper Contributor
SergeiBaklan That did the trick, thank you for your help!
SergeiBaklan
Jan 25, 2023Diamond Contributor
austinugonzalez , you are welcome