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
 
Top