Hi,
i'm looking to create a formula that counts the number of Mondays in a given cell range which contain a mixture of dates and empty cells ("").
i have used =SUMPRODUCT((WEEKDAY(A11:A23)=2)*1) , but this doesn't seem to work with cells that are =""
Any chance someone could help please.
Thanks in advance
Suban
Bookmarks