WEEKDAY in EXCEL 2003

[RM]

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?

 

[Jacob Skaria]

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

If this post helps click Yes

 

[RM]

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

 

[Jacob Skaria]

(1-weekday)

for sat
1-7

If this post helps click Yes

 

[Chip Pearson]

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)