I have found the following formula for counting the numbers of Mondays between a start and end date
{SUMPRODUCT(--(WEEKDAY(StartDate-1+ROW(INDIRECT("1:"&(EndDate-StartDate+1))))=2))}
Would anyone can tell me how these "--" work and what they stand for.
Bookmarks