Cell D2 : Data validation for Month Name
Cell E2: Data validation for Weekday Name
Formula in F2:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(DATE(YEAR(D2),MONTH(D2),1)&":"&EOMONTH(D2,0))))=MATCH(E2,{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"},0)))
Note: Make sure the month name list (A2:A13 in my case) that you are using for data Validation, is in date format, not in text format.
Is the post helpful?
Please post your valuable comment. Thanks!