Here’s a post from @Steve that you should find helpful:
[Count A certain day in a Mounth](https://community.appsheet.com/t/count-a-certain-day-in-a-mounth/13036/4) Questions
You can try this expression to identify how many times a given weekday (1-7 for Sun-Sat) occurs in a month containing a given date: ceiling( day( eomonth([date], 0) - weekday(eomonth([date], 0)) - ifs(([weekday] > weekday(eomonth([date], 0))), 7) + [weekday] ) / 7.0 ) eomonth([date], 0) gets the date of the last day of the month that contains [date]. weekday(eomonth([date], 0)) get the number of the weekday of that last day of the month. eomonth(…) - weekday(……