Weekend / Non Weekend Days

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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
 
=SUMPRODUCT(1*(WEEKDAY(ROW(INDIRECT(DATE(YEAR(A1),MONTH(A1),1)&":"&DATE(YEAR(A1),MONTH(A1)+1,0))))={1,7}))

Bob Umlas
Excel MVP
 
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
 
Give this formula a try...

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