Below is a possible solution to the challenge – Challenge 22 – Another Friday the 13th Challenge – Find Actual Dates themselves
If A1 and A2 contain the start and end dates, put following formula and drag down –
=IFERROR(AGGREGATE(15,6,(ROW(INDIRECT($A$1&":"&$A$2)))/((TEXT(ROW(INDIRECT($A$1&":"&$A$2)),
"ddd")="Fri")*(TEXT(ROW(INDIRECT($A$1&":"&$A$2)),"dd")="13")),ROWS($1:1)),"")
A workbook illustrating the same can be downloaded from Solution – Challenge 22 – Another Friday the 13th Challenge – Find Actual Dates themselves