WEEKDAY in EXCEL 2003

  • Thread starter Thread starter RM
  • Start date Start date
R

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?
 
This worked great. However, what numbers do I change depending on the day of
the week I want to count?
 
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)
 
Back
Top