Results 1 to 5 of 5

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 & ...

  1. #1
    Board Regular
    Join Date
    Jun 2002
    Posts
    106

    Default 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. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,948

    Default 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.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular Iridium's Avatar
    Join Date
    Jul 2002
    Location
    West Bridgford, Notts., England
    Posts
    2,834

    Default Re: Weekdays in a Month

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

    HTH
    Iridium


  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default 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. #5
    Board Regular
    Join Date
    Jun 2002
    Posts
    106

    Default Re: Weekdays in a Month

    Nice one, Thanks

    j.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com