I have a list of dates in the following format DD/MM/YYYY
I have another cell with a month that has been typed into it (e.g. "November")
I wish to count the dates that feature in the month name in the other cell.
I have tried the following, but cant get it to work...
=SUMPRODUCT((MONTH('Live Data'!B5:B7)=Summary!D6))
B5:B7 is the list of dates
D6 is the month that has been typed
Thank you guys
Bookmarks