Solution – Challenge 65 – How Many Sundays on Last Date of Months

Below is a possible solution to the Challenge 65 – How Many Sundays on Last Date of Months

=SUMPRODUCT((ROW(INDIRECT($B$1&":"&$B$2))=EOMONTH(ROW(INDIRECT(
$B$1&":"&$B$2)),0))*(TEXT(ROW(INDIRECT($B$1&":"&$B$2)),"ddd")="Sun"))

Below is an Excel sheet containing the solution

Solution – Challenge 65 – How Many Sundays on Last Date of Months