=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)=1))

=INT((A2-WEEKDAY(A2)-A1+9)/7)

start date in A1 end in A2


Regards,

Peo Sjoblom

"nico" wrote:

Hello,
can someone tell me a way to calculate the number of mondays (or any other
weekday) between two specified dates? The formula should not use arrays, of
possible, as I'm trying to add it to an existing formula adding stuff
relating to months, already. Thanks,
Nico