+ Reply to Thread
Results 1 to 3 of 3

Workdays in Month

Hybrid View

  1. #1
    Registered User
    Join Date
    10-03-2010
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2013
    Posts
    38

    Workdays in Month

    I need a function that returns the workdays in any given month/year.
    Bonus if it also excludes holidays.

    Thanks,
    Art

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Workdays in Month

    Given Year in A1, Month(number) in B1
    C1:C20 = list of holiday dates you create to be excluded from the count.

    =NETWORKDAYS(DATE(A1,B1,1),DATE(A1,B1+1,0),C1:C20)

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Workdays in Month

    One way...

    A2 = the 1st of the month date for the month/year of interest. For example, 8/1/2013

    B2:B15 = list of holiday dates to be excluded from the count

    Enter this formula in C2:

    =NETWORKDAYS(A2,EOMONTH(A2,0),B2:B15)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Count workdays for each month between two dates
    By MitchellG in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-16-2013, 02:01 PM
  2. Enter month - return workdays
    By derek3191 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-05-2013, 11:39 AM
  3. [SOLVED] How many workdays are left in the month
    By crazyape in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2012, 12:22 PM
  4. How to calculate workdays in a month?
    By ExcelNewby in forum Excel General
    Replies: 4
    Last Post: 06-19-2008, 06:26 PM
  5. Number of workdays in a month
    By Nigel Bennett in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2005, 08:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1