2
votes
Excel 2013: Analyzing Multiple Dates within a single Cell using IF statements
Since you are using Excel 2013 then with the FILTERXML() function (Windows Excel 2013+), you can use:
• Formula used in cell B1
=IF(SUM((FILTERXML("<m><b>"&SUBSTITUTE(A1,&...
1
vote
Excel 2013: Analyzing Multiple Dates within a single Cell using IF statements
=IF(
SUM(
(--TRIM(MID(SUBSTITUTE(A1,",",REPT(" ",LEN(A1))),LEN(A1)*(ROW(A1:INDEX(A:A,1+LEN(A1)-LEN(SUBSTITUTE(A$1,",",""))))-1)+1,LEN(A1)))>45017)...
- 313
Only top scored, non community-wiki answers of a minimum length are eligible