number of mondays in period

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating the number of a Mondays between two dates 2
Work days 6
Date calculation for Monday of one month to the Monday of the next 19
Count the Number of Weekdays by Month 3
Days in a specific month 2
Calculate number of Mondays betweeb 2 dates 6
Find date of first Monday of each month 7
Find number of weekdays and wekend days given a total number of da 7

Back
Top