Forum Discussion
Counting Dates
Excel 2013 and later:
=SUMPRODUCT(0+(TEXT(FILTERXML("<a><b>"&SUBSTITUTE(A1,",","</b><b>")&"</b></a>","//b"),"mmmm")="September"))
Amend month as required.
Slightly more involved if you're on a pre-2013 version of Excel. Let me know.
Regards
Excel 2013 and later:
=SUMPRODUCT(0+(TEXT(FILTERXML("<a><b>"&SUBSTITUTE(A1,",","</b><b>")&"</b></a>","//b"),"mmmm")="September"))
Amend month as required.
Slightly more involved if you're on a pre-2013 version of Excel. Let me know.
Regards
This is exactly what I was looking for! Genius Thank you. Jos_Woolley
OK. Now how would I pull out the largest date from that same list? I hope you don't mind me asking you for more help. Jos_Woolley
Of course I don't mind!
I take it you have Excel 2013 or later, then?
=AGGREGATE(14,,FILTERXML("<a><b>"&SUBSTITUTE(A1,",","</b><b>")&"</b></a>","//b"),1)
Regards