How to count the number of each day of week within a certain date range?

[jmigner]

Hello!

I have a table which has the dat range for my database and the day-of-week for each date. In my report, I want a formula which counts the number of each day of the week (e.g. 5 Monday's in May 2017) based on the date filter applied. I have tried a few different count formulas and they have not been working. Any ideas?

Thanks,

Julia

[GilbertQ · Accepted solution]

Hi @jmigner

You could just do a COUNTROWS for your date table, and then when you select each month, it would then just count the number of days when you put the Day Name into a table?

Here is an example below.