+ Reply to Thread
Results 1 to 5 of 5

How to calculate workdays

Hybrid View

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    21

    How to calculate workdays

    Dear excel forum,

    i have problem in calculating wordays
    commonly, there are 5 workdays in a week.
    What about 6 days? Because my offday just on friday.
    Count
    start day 01/10/2013 sunday ?
    End day 31/10/2013 monday ?
    Tuesday ?
    Holiday 14/10/2013 wednesday ?
    15/10/2013 thursday ?
    Friday ?
    Saturday ?

    Offday=saturday,sunday
    workday 21

    offday=friday
    workday ???
    LIKE IN ATTACHMENT

    Thank you!
    Attached Files Attached Files
    Last edited by mnur; 10-08-2013 at 03:29 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,603

    Re: How to calculate workdays

    Try the improved NETWORKDAYS function by Chip Pearson

  3. #3
    Registered User
    Join Date
    03-25-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: How to calculate workdays

    Wow, it works Pepe...
    By the way, what about the calculating the days? Such as in my attachment:
    Sunday ... days?
    Monday ... days?
    And so on
    Thank you
    Last edited by mnur; 10-08-2013 at 04:17 AM.

  4. #4
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: How to calculate workdays

    hi mnur. maybe this in E2:
    =SUMPRODUCT(--(TEXT(ROW(INDIRECT($B$2&":"&$B$3)),"dddd")=D2))
    if you exclude the holidays, it would be:
    =SUMPRODUCT(--(TEXT(ROW(INDIRECT($B$2&":"&$B$3)),"dddd")=D2),--(COUNTIF($B$5:$B$6,ROW(INDIRECT($B$2&":"&$B$3)))=0))

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  5. #5
    Registered User
    Join Date
    03-25-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: How to calculate workdays

    thanks benishiryo,
    i've tried the formula, it works very well.
    Last edited by mnur; 10-08-2013 at 10:03 AM.

+ 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. [SOLVED] Calculate Workdays
    By mycon73 in forum Excel General
    Replies: 11
    Last Post: 12-28-2012, 01:38 AM
  2. How to calculate workdays in a month?
    By ExcelNewby in forum Excel General
    Replies: 4
    Last Post: 06-19-2008, 06:26 PM
  3. How do you calculate workdays if Saturday is a workday?
    By Tracy Parish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-06-2006, 07:24 PM
  4. How do you calculate number of workdays from dates entered?
    By t_fleck@hotmail.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2005, 09:41 AM
  5. How do you calculate number of workdays from dates entered?
    By tfleck in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-25-2005, 06:06 PM

Tags for this Thread

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