Weekend / Non Weekend Days

[Andrew]

Hi

I would appreciate it if someone could tell me the formaula to retrieve the
number of weekend days in any given month e.g. January 2011.

Many thanks,

Andrew

 

[Bob Umlas]

=SUMPRODUCT(1*(WEEKDAY(ROW(INDIRECT(DATE(YEAR(A1),MONTH(A1),1)&":"&DATE(YEAR(A1),MONTH(A1)+1,0))))={1,7}))

Bob Umlas
Excel MVP

 

[Pete_UK]

If you have Excel 2007, or if you have the Analysis ToolPak installed
for earlier versions, then NETWORKDAYs will give you the number of
working days between a start and end date, so you could subtract this
from the number of days in the month to get weekend days.

Hope this helps.

Pete

 

[Rick Rothstein]

Give this formula a try...

=SUMPRODUCT((WEEKDAY(A1-DAY(A1)+ROW(1:31),2)>5)*(MONTH(A1-DAY(A1)+ROW(1:31))=MONTH(A1)))

 

[Bernd P]

Hello Andrew,

If A1 is the first and A2 is the last day of your month:
=INT((A2-MOD(A2-1,7)-A1+7)/7)+INT((A2-MOD(A2-7,7)-A1+7)/7)

This is a special case (counting Saturdays and Sundays) of the first
formula presented at:
http://sulprobil.com/html/date_formulas.html

Regards,
Bernd