+ Reply to Thread
Results 1 to 3 of 3

Counting specific days in a range?

  1. #1
    Registered User
    Join Date
    06-25-2011
    Location
    Chicago, IL
    MS-Off Ver
    MS 365 apps for business
    Posts
    63

    Counting specific days in a range?

    I'm building a forecast for a company that pays employees every 10th and 25th of the month. The pay period starts on the 8th and the 23rd of every month and ends on the 7th and 22nd of every month. Employees work 8 hours a day, but they only work on weekdays. Based on these constraints sometimes the days an employee needs to be paid for during a period can range wildly based on where weekends fall and the month (sometimes 13 days, 14, 15, 16, etc).

    I've ran into similiar problems like this before. How can I set up the file in a way where I can count just the cells I want to count based on where the "breaks" are from one period to a new period?

    In the attached example I've setup the problem with a manual plugged solution in column H. Appreciate any help on how to solve this problem. I can't use macros for the solution. Thank you!
    Attached Files Attached Files

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

    Re: Counting specific days in a range?

    In H4:
    Please Login or Register  to view this content.
    Drag down.
    Quang PT

  3. #3
    Registered User
    Join Date
    06-25-2011
    Location
    Chicago, IL
    MS-Off Ver
    MS 365 apps for business
    Posts
    63

    Re: Counting specific days in a range?

    That solution works - and works well - thank you! Now I need to understand why it works. Not used to SUMPRODUCT.

+ 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] Function for counting days between 2 dates for specific year
    By erthmill in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-09-2016, 04:14 PM
  2. [SOLVED] Function for counting days between 2 dates for specific year
    By erthmill in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-09-2016, 12:58 PM
  3. Replies: 5
    Last Post: 08-17-2015, 05:38 AM
  4. [SOLVED] Counting specific days between dates
    By floxxie in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-14-2014, 08:44 AM
  5. [SOLVED] Counting Specific Values & Days of the Week
    By bugmenot in forum Excel General
    Replies: 3
    Last Post: 01-23-2009, 04:38 AM
  6. counting specific days from unique records
    By ceemo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-24-2005, 05:04 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