Hi,
I am struggling with an excel array formula.
=SUM((WEEKDAY(DATE($T$2,S$4, ROW(INDIRECT("1:"& DAY(DATE($T$2,S$4+1,0))))))=U$1)*1)
This formula is being used to calculate number of sundays, mondays etc within February month in 2011. I fail to understand the relevance of "1:" in the formula and *1 used at the end. Can you please help in understanding their significance. When are these symbols generally used in an array formula.

Thanks

T2 cell contains 2011 year
S4 cell contains no. 2 for February