Weekdays in a month

  • Thread starter Thread starter Simon Lee
  • Start date Start date
S

Simon Lee

Hi,
I would like to know how can i count the weekdays in a
month?
i know this formula counts the days in a month, but this
includes weekends as well.
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))

Please help.
Thanks so much in advance.

Regards,
Simon Lee
 
Hi Simon!

You can use the NETWORKDAYS function:

=NETWORKDAYS("1-Jan-2004","31-Jan-2004")

For any month where a date in that month is given in A1:

=NETWORKDAYS(DATE(YEAR(A1),MONTH(A1),1),DATE(YEAR(A1),MONTH(A1)+1,0))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Try this:
in A1:A12 enter the 1st of Jan.......1st of Dec
in B1 enter =NETWORKDAYS(A1,EOMONTH(A1,0))
copy down.

Or;
the longer version:
=SUM((WEEKDAY(AJ79+ROW(INDIRECT("1:"&(DATE(YEAR(AJ79),MONTH(AJ79)+1,1))-AJ79))-1,2)<6)*1)
confirm with control, shift, enter
 
thanks 2rrs, it works!!!!
You're the greatest.

-----Original Message-----
Try this:
in A1:A12 enter the 1st of Jan.......1st of Dec
in B1 enter =NETWORKDAYS(A1,EOMONTH(A1,0))
copy down.

Or;
the longer version:
=SUM((WEEKDAY(AJ79+ROW(INDIRECT("1:"&(DATE(YEAR (AJ79),MONTH(AJ79)+1,1))-AJ79))-1,2)<6)*1)
confirm with control, shift, enter

"Simon Lee" <[email protected]> wrote in message
.
Click to expand...
 
Back
Top