COUNTIF sort by date?

[austinugonzalez]

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

[#2 · Accepted solution]

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

[#3]

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

[#4]

@austinugonzalez , you are welcome