Does anyone have an efficient, simple algorithm for calculating the
number of occurrences of a weekday between 2 dates? I don't want to
step through each day and use a weekday function to check the day of
week and increment a counter. I'm using VBA so I have all the built in
VBA date/time functions.

---

Request for Question Clarification by mathtalk-ga on 20 Apr 2004 08:38 PDT

So, for example, given date "Apr 2, 1979" and "Dec 14, 2003", you'd
like to know how many Wednesdays occur in between?

Do you include the endpoints in your count (it doesn't make the task
harder one way or the other, but it requires a specification)?

Depending on how you count the endpoints, it suffices to know the date
of the week for the first date and the number of days between the two
dates.

regards, mathtalk-ga

---

Clarification of Question by codemasterjs-ga on 21 Apr 2004 06:30 PDT

yes that's exactly it, and I would like it to include endpoints