I have a number of functions related to days of the week and days of
the month at http://www.cpearson.com/Excel/DayOfWeekFunctions.aspx .
The functions are implemented as both Excel formulas and VBA
functions.

For the number of DayOfWeek days between StartDate and EndDate, use a
formula like:

=((EndDate-MOD(WEEKDAY(EndDate)-DayOfWeek,7)-
StartDate-MOD(DayOfWeek-WEEKDAY(StartDate),7))/7)+1

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Thu, 17 Sep 2009 10:25:26 -0700, RM
wrote:

I need to be able to count the number of Saturdays between start and end
dates, i.e., a1 = 9/21/2009; b1 = 2/19/2010; c1 = No. of Saturdays

Can anyone help?