# Weekdays in a Month

This is a discussion on Weekdays in a Month within the Excel Questions forums, part of the Question Forums category; Hi, I am just wondering if there is a formula which works out how many week days (Excl Sat &amp; ...

1. ## Weekdays in a Month

Hi,

I am just wondering if there is a formula which works out how many week days (Excl Sat & Sun) there are in a particular month.

eg: how many in Jan 03, how many in Feb 03 etc..

Is there an excel formula that does this?

J.

2. ## Re: Weekdays in a Month

Assuming that A1 has an entry like

01/01/03

you can use a formula like this:

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

NETWORKDAYS requires the Analysis ToolPak AddIn to be installed.

3. ## Re: Weekdays in a Month

Check out NETWORKDAYS in the xl help (you'll need the Analysis Toolpak)

HTH

4. ## Re: Weekdays in a Month

See the NETWORKDAYS worksheet function which is supplied by the Analysis ToolPak Add-in. In addition to the recommendations above you could also use...

=NETWORKDAYS(A1,EOMONTH(A1,0))

5. ## Re: Weekdays in a Month

Nice one, Thanks

j.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•