+ Reply to Thread
Results 1 to 4 of 4

Count dates in a row within a specific week.

  1. #1
    Registered User
    Join Date
    07-31-2016
    Location
    Holland
    MS-Off Ver
    2011
    Posts
    66

    Count dates in a row within a specific week.

    Hi all,

    I need help as I am totally blank in how to solve this.

    I have sheet with a row of random dates. I need to count the dates within a specific week (form Monday to Friday) the specific week number is in textbox1 the specific year is in textbox2.

    I tried to work with Application.WorksheetFunction.CountIfs, and weeknum but at the moment I am totally stuck in how to solve this.

    looking forwards to any help!

  2. #2
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,212
    Please Login or Register  to view this content.
    Or
    Please Login or Register  to view this content.
    Last edited by AliGW; 10-20-2018 at 10:24 AM. Reason: Unnecessary quotation removed.

  3. #3
    Registered User
    Join Date
    07-31-2016
    Location
    Holland
    MS-Off Ver
    2011
    Posts
    66

    Re: Count dates in a row within a specific week.

    Thanks for your time, both do not work. unfortunately they are to complex for me to modify them. If you need more information so that they will work please let me know.

  4. #4
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    70

    Re: Count dates in a row within a specific week.

    Can you send a excel sheet with sample data and expected result

+ 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 dates last week, Mon-Fri
    By bsl13 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-25-2018, 11:41 AM
  2. Count days of week based on dates and specific text
    By elv28 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-20-2018, 01:23 AM
  3. Count workdays between 2 dates per week
    By Framboosje in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-01-2018, 01:35 PM
  4. [SOLVED] Return a value between 2 dates on a specific day of the week
    By trolle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2017, 07:05 AM
  5. [SOLVED] Rounding dates to specific working days of the week
    By Sarah C in forum Excel General
    Replies: 7
    Last Post: 07-13-2016, 12:19 PM
  6. [SOLVED] Working with specific dates against Week Commencing dates
    By daveb86 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-11-2015, 05:36 AM
  7. need to convert list of dates to count no. of dates by week
    By neowok in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-30-2006, 11:54 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