Forum Discussion
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 keep a tally by type, but I would like to keep track on a weekly basis. Is there a way to add a date function to stop counting at the end of the week and start keeping a new tally each week automatically when the new info is inputted.?
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.
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 That did the trick, thank you for your help!
austinugonzalez , you are welcome
