Formula to count the how many times "Monday" is listed

Arrie Hanson

This is for a ticketing system. I want to count the number of requests that come in on each day of the week. I am looking for a rolling YTD number.

I have a metrics sheet that pulls the data from a closed tickets sheet.

This is the formula I tried using:

=COUNTIFS({Resolved Date Range}, CONTAINS("Monday", @cell))

Any help would be appreciated.

Andrée Starå

Hi @Arrie Hanson

I hope you're well and safe!

Try something like this.

=COUNTIF({Resolved Date Range}, IFERROR(WEEKDAY(@cell), 0) = 2)

2=Monday, 3=Tuesday...

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Arrie Hanson

I hope you're well and safe!

Try something like this.

=COUNTIF({Resolved Date Range}, IFERROR(WEEKDAY(@cell), 0) = 2)

2=Monday, 3=Tuesday...

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Arrie Hanson

Yes! That works like a charm. Thank you so much.

Andrée Starå

@Arrie Hanson

Excellent!

You're more than welcome!