+ Reply to Thread
Results 1 to 4 of 4

Calculate no of working days in a month

  1. #1
    Registered User
    Join Date
    03-16-2014
    Location
    Cluj Napoca, Romania
    MS-Off Ver
    Excel 2007
    Posts
    4

    Calculate no of working days in a month

    Hello,

    I want to calculate the no. of working days in a month.
    My data looks like this: B2= Feb/2014 and in B3 I would like to have 20 day (working days in that month).

    Thank you, in advance!

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,447

    Re: Calculate no of working days in a month

    Try:

    =NETWORKDAYS(B2,EOMONTH(B2,0))
    Quang PT

  3. #3
    Registered User
    Join Date
    12-15-2012
    Location
    In a bin
    MS-Off Ver
    Excel 2013
    Posts
    43

    Re: Calculate no of working days in a month

    Try the following:

    =NETWORKDAYS(EOMONTH(B2,-1)+1,EOMONTH(B2,0))

    As you do not have a day for the Feb date.

  4. #4
    Registered User
    Join Date
    03-16-2014
    Location
    Cluj Napoca, Romania
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Calculate no of working days in a month

    Thank you! it worked.

+ 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. vba code needed to calculate the number of working days thus far for the month
    By Jim885 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2014, 09:38 PM
  2. [SOLVED] Formula needed to calculate working days in specified month between two dates
    By webfeet2 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-24-2013, 02:19 AM
  3. Calculate total working days and excepted leave days
    By megaiooo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-21-2013, 09:29 AM
  4. Show days in a month dynamically + working days
    By vemix in forum Excel General
    Replies: 5
    Last Post: 12-28-2012, 07:54 AM
  5. Calculate Days in a Month
    By LGG in forum Excel General
    Replies: 6
    Last Post: 01-13-2006, 02:35 PM

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