Calculating the number of a Mondays between two dates

A

AChua

Is there a function which can calculate the number of a specified weekday
between two dates?
e.g. How many Mondays there are between 01/07/08 and 01/08/08?
 
R

Ron Rosenfeld

Is there a function which can calculate the number of a specified weekday
between two dates?
e.g. How many Mondays there are between 01/07/08 and 01/08/08?
Click to expand...

In general:

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


Where

A2: End Date
A1: Start DAte
DOW: Day of week (Sun=1, Mon=2, ...)
--ron
 

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

counting based on two dates 2
number of mondays in period 3
Days of week between dates 4
calculate number of days 7
Counting Entries between two dates 3
Date Difference in Complete Tax Years 1
Middle date of two dates 3
Date Axis 5

Top