+ Reply to Thread
Results 1 to 3 of 3

Counting work days, not weekends

  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    Illinois
    MS-Off Ver
    Microsoft 360
    Posts
    58

    Counting work days, not weekends

    Hello everyone,

    I always need to count the number of workdays it takes to produce an item in my shop. I only count Monday thru Friday, but never count Saturdays or Sundays. We put the start date in A1 and the finish date in B1 and do the simple calculation in cell C1 of B1-A1. However, that adds the weekend days. What formula can I use this to calculate only Mondays thru Fridays? Seems like we have to somehow designate which dates are weekend dates. Any help would be greatly appreciated ... thanks much!

    Joe

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,406

    Re: Counting work days, not weekends

    Hi,

    Have you tried

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You can also include a list of public holidays as a third parameter range should you wish to exclude those too.
    Last edited by Richard Buttrey; 11-13-2013 at 02:44 PM.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    09-18-2012
    Location
    Illinois
    MS-Off Ver
    Microsoft 360
    Posts
    58

    Re: Counting work days, not weekends

    Thanks Richard ... that works great. I had a feeling there was a simple formula. Holidays are an issue but I'll work at the third parameter as you suggested. I appreciate it.

+ 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] Count only work days, not weekends
    By greenjl7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2013, 11:56 AM
  2. Counting number of days less weekends.
    By maacmaac in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-29-2008, 08:04 PM
  3. Replies: 5
    Last Post: 07-11-2006, 01:56 PM
  4. Difference between 2 dates, incl weekends, with variable work days
    By babryanton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-07-2006, 06:24 PM
  5. [SOLVED] How do you count work days excluding weekends and holidays?
    By Hausma in forum Excel General
    Replies: 2
    Last Post: 04-08-2005, 03: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