Count occurrences of "Monday" in a different sheet from a given date range
Depending on your version of Excel:
=COUNT(FILTER(Sheet1!$A:$A,(Sheet1!$A:$A>=from_date)*(Sheet1!$A:$A<=to_date)*(WEEKDAY(Sheet1!$A:$A)=2)))
The above formula will work in Excel Office 365