Weekdays in a month

[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

 

[Frank Kabel]

Hi Simon
have a look at
http://www.cpearson.com/excel/DateTimeWS.htm

Frank

 

[Norman Harker]

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.

 

[2rrs]

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

 

[Guest]

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
.