Need number of Saturdays and number of Sundays between 2 dates

[Class316]

In excel I use the formula =networkdays(A1,A2) [where A1 and A2 are dates] to get the number of weekdays between 2 dates. Is there a formula to get the number of Saturdays and number of Sundays?

So basically there are 2 dates, I need the number of Saturdays between these dates, and another formula for number of Sundays.

Would appreciate any help. Thanks.

[Jason Morin]

For Saturdays, try:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=7))

For Sundays, change the 7 to a 1.

HTH
Jason
Atlanta, GA

"Class316" wrote:

>
> In excel I use the formula =networkdays(A1,A2) [where A1 and A2 are
> dates] to get the number of weekdays between 2 dates. Is there a
> formula to get the number of Saturdays and number of Sundays?
>
> So basically there are 2 dates, I need the number of Saturdays between
> these dates, and another formula for number of Sundays.
>
> Would appreciate any help. Thanks.
>
>
> --
> Class316
> ------------------------------------------------------------------------
> Class316's Profile: http://www.excelforum.com/member.php...o&userid=24163
> View this thread: http://www.excelforum.com/showthread...hreadid=377935
>
>

[Jason Morin]

For Saturdays, try:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=7))

For Sundays, change the 7 to a 1.

HTH
Jason
Atlanta, GA

"Class316" wrote:

>
> In excel I use the formula =networkdays(A1,A2) [where A1 and A2 are
> dates] to get the number of weekdays between 2 dates. Is there a
> formula to get the number of Saturdays and number of Sundays?
>
> So basically there are 2 dates, I need the number of Saturdays between
> these dates, and another formula for number of Sundays.
>
> Would appreciate any help. Thanks.
>
>
> --
> Class316
> ------------------------------------------------------------------------
> Class316's Profile: http://www.excelforum.com/member.php...o&userid=24163
> View this thread: http://www.excelforum.com/showthread...hreadid=377935
>
>

[Jason Morin]

For Saturdays, try:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=7))

For Sundays, change the 7 to a 1.

HTH
Jason
Atlanta, GA

"Class316" wrote:

>
> In excel I use the formula =networkdays(A1,A2) [where A1 and A2 are
> dates] to get the number of weekdays between 2 dates. Is there a
> formula to get the number of Saturdays and number of Sundays?
>
> So basically there are 2 dates, I need the number of Saturdays between
> these dates, and another formula for number of Sundays.
>
> Would appreciate any help. Thanks.
>
>
> --
> Class316
> ------------------------------------------------------------------------
> Class316's Profile: http://www.excelforum.com/member.php...o&userid=24163
> View this thread: http://www.excelforum.com/showthread...hreadid=377935
>
>

[Jason Morin]

For Saturdays, try:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=7))

For Sundays, change the 7 to a 1.

HTH
Jason
Atlanta, GA

"Class316" wrote:

>
> In excel I use the formula =networkdays(A1,A2) [where A1 and A2 are
> dates] to get the number of weekdays between 2 dates. Is there a
> formula to get the number of Saturdays and number of Sundays?
>
> So basically there are 2 dates, I need the number of Saturdays between
> these dates, and another formula for number of Sundays.
>
> Would appreciate any help. Thanks.
>
>
> --
> Class316
> ------------------------------------------------------------------------
> Class316's Profile: http://www.excelforum.com/member.php...o&userid=24163
> View this thread: http://www.excelforum.com/showthread...hreadid=377935
>
>

[Jason Morin]

For Saturdays, try:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=7))

For Sundays, change the 7 to a 1.

HTH
Jason
Atlanta, GA

"Class316" wrote:

>
> In excel I use the formula =networkdays(A1,A2) [where A1 and A2 are
> dates] to get the number of weekdays between 2 dates. Is there a
> formula to get the number of Saturdays and number of Sundays?
>
> So basically there are 2 dates, I need the number of Saturdays between
> these dates, and another formula for number of Sundays.
>
> Would appreciate any help. Thanks.
>
>
> --
> Class316
> ------------------------------------------------------------------------
> Class316's Profile: http://www.excelforum.com/member.php...o&userid=24163
> View this thread: http://www.excelforum.com/showthread...hreadid=377935
>
>

[Jason Morin]

For Saturdays, try:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=7))

For Sundays, change the 7 to a 1.

HTH
Jason
Atlanta, GA

"Class316" wrote:

>
> In excel I use the formula =networkdays(A1,A2) [where A1 and A2 are
> dates] to get the number of weekdays between 2 dates. Is there a
> formula to get the number of Saturdays and number of Sundays?
>
> So basically there are 2 dates, I need the number of Saturdays between
> these dates, and another formula for number of Sundays.
>
> Would appreciate any help. Thanks.
>
>
> --
> Class316
> ------------------------------------------------------------------------
> Class316's Profile: http://www.excelforum.com/member.php...o&userid=24163
> View this thread: http://www.excelforum.com/showthread...hreadid=377935
>
>

[Jason Morin]

For Saturdays, try:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=7))

For Sundays, change the 7 to a 1.

HTH
Jason
Atlanta, GA

"Class316" wrote:

>
> In excel I use the formula =networkdays(A1,A2) [where A1 and A2 are
> dates] to get the number of weekdays between 2 dates. Is there a
> formula to get the number of Saturdays and number of Sundays?
>
> So basically there are 2 dates, I need the number of Saturdays between
> these dates, and another formula for number of Sundays.
>
> Would appreciate any help. Thanks.
>
>
> --
> Class316
> ------------------------------------------------------------------------
> Class316's Profile: http://www.excelforum.com/member.php...o&userid=24163
> View this thread: http://www.excelforum.com/showthread...hreadid=377935
>
>

[Jason Morin]

For Saturdays, try:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=7))

For Sundays, change the 7 to a 1.

HTH
Jason
Atlanta, GA

"Class316" wrote:

>
> In excel I use the formula =networkdays(A1,A2) [where A1 and A2 are
> dates] to get the number of weekdays between 2 dates. Is there a
> formula to get the number of Saturdays and number of Sundays?
>
> So basically there are 2 dates, I need the number of Saturdays between
> these dates, and another formula for number of Sundays.
>
> Would appreciate any help. Thanks.
>
>
> --
> Class316
> ------------------------------------------------------------------------
> Class316's Profile: http://www.excelforum.com/member.php...o&userid=24163
> View this thread: http://www.excelforum.com/showthread...hreadid=377935
>
>

[Jason Morin]

For Saturdays, try:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=7))

For Sundays, change the 7 to a 1.

HTH
Jason
Atlanta, GA

"Class316" wrote:

>
> In excel I use the formula =networkdays(A1,A2) [where A1 and A2 are
> dates] to get the number of weekdays between 2 dates. Is there a
> formula to get the number of Saturdays and number of Sundays?
>
> So basically there are 2 dates, I need the number of Saturdays between
> these dates, and another formula for number of Sundays.
>
> Would appreciate any help. Thanks.
>
>
> --
> Class316
> ------------------------------------------------------------------------
> Class316's Profile: http://www.excelforum.com/member.php...o&userid=24163
> View this thread: http://www.excelforum.com/showthread...hreadid=377935
>
>

[Jason Morin]

For Saturdays, try:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=7))

For Sundays, change the 7 to a 1.

HTH
Jason
Atlanta, GA

"Class316" wrote:

>
> In excel I use the formula =networkdays(A1,A2) [where A1 and A2 are
> dates] to get the number of weekdays between 2 dates. Is there a
> formula to get the number of Saturdays and number of Sundays?
>
> So basically there are 2 dates, I need the number of Saturdays between
> these dates, and another formula for number of Sundays.
>
> Would appreciate any help. Thanks.
>
>
> --
> Class316
> ------------------------------------------------------------------------
> Class316's Profile: http://www.excelforum.com/member.php...o&userid=24163
> View this thread: http://www.excelforum.com/showthread...hreadid=377935
>
>