counting days

**Xtopher** · 05-25-2010, 06:44 PM

G'Day all,

I'm trying to devise a formula that will count the amount of saturdays and sundays within a given date range.

Is this feasible within Excel?

**JBeaucaire** · 05-25-2010, 06:55 PM

Start Date in A1
End Date in A2

This formula will tell you how many Mondays are in the range:

=INT((A2 - A1 + WEEKDAY(A1 - 2)) / 7)

The number in RED is the key to what day is being counted.

1=Sundays
2=Mondays
etc....

Hat tip to Richard Schollar:
(source)

**Xtopher** · 05-25-2010, 07:18 PM

Originally Posted by JBeaucaire

Start Date in A1
End Date in A2

This formula will tell you how many Mondays are in the range:

=INT((A2 - A1 + WEEKDAY(A1 - 2)) / 7)

The number in RED is the key to what day is being counte.

1=Sundays
2=Mondays
etc....

Hat tip to Richard Schollar:
(source)

Thanks JB, but can this formula support multiple days?

Saturday & Sunday?

**daddylonglegs** · 05-25-2010, 07:20 PM

....extending that, then, to count both Saturdays and Sundays, you can use this version

=SUM(INT((A2 - A1 + WEEKDAY(A1 - {1,7})) / 7))

.....or you could use the NETWORKDAYS formula in reverse. NETWORKDAYS counts non-weekend days so you can subtract that count from a count of the total days in your range, i.e.

=A2-A1+1-NETWORKDAYS(A1,A2)