>The brain just refuses to yield on this one.
>I need to calculate the number of Fridays (or any day) between 11/01/20 and 01/31/21.
>The column the table in question - coindrop- is a datetime called dropdate.
>I can determine that 815 rows happened on Friday during that time period.
>The next question is - how may happened on the average Friday, for example?
>Any ideas?

Just spitballing off the top o'me head here:

Select count(*) as FriCnt, DropDate from CoinDrop
where DateName(dw, DropDate) = 'Friday'
group by DropDate

or summat as a start