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?

Try
=INT((B1-WEEKDAY(B1+1-7)-A1+8)/7)

If this post helps click Yes
---------------
Jacob Skaria


"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?

This worked great. However, what numbers do I change depending on the day of
the week I want to count?

"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?

(1-weekday)

for sat
1-7

If this post helps click Yes
---------------
Jacob Skaria


"RM" wrote:

This worked great. However, what numbers do I change depending on the day of
the week I want to count?

"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?

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?