## Solution - Challenge 22 – Another Friday the 13th Challenge – Find Actual Dates themselves

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