number of mondays in period

N

nico

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
 
P

Peo Sjoblom

=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
 
R

Ron Rosenfeld

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
Click to expand...


=INT((A2-WEEKDAY(A2-1)-A1+8)/7)


--ron
 
Top