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

=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

On Thu, 9 Jun 2005 13:49:04 -0700, "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


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


--ron

On Thu, 09 Jun 2005 18:53:07 -0400, Ron Rosenfeld
wrote:

On Thu, 9 Jun 2005 13:49:04 -0700, "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


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



courtesy of Daniel M. by the way


--ron