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