COUNTIF sort by date?

New Contributor

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.?

3 Replies
best response confirmed by Hans Vogelaar (MVP)


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.

@Sergei Baklan That did the trick, thank you for your help!

@austinugonzalez , you are welcome