SOLVED

# COUNTIF sort by date?

Copper 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 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)
Solution

# Re: COUNTIF sort by date?

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.

# Re: COUNTIF sort by date?

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

# Re: COUNTIF sort by date?

@austinugonzalez , you are welcome

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: COUNTIF sort by date?

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.