+ Reply to Thread
Results 1 to 3 of 3

How to count 10 consecutive week days

  1. #1
    Registered User
    Join Date
    09-03-2013
    Location
    Reading
    MS-Off Ver
    Excel 2010
    Posts
    25

    How to count 10 consecutive week days

    Hi

    Could you help me count the 10 consecutive week days for each person on my list?

    See the attached spreadsheet. I just need to record a yes for anyone who has 10 consecutive days in the list.

    Thanks.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: How to count 10 consecutive week days

    Hi,

    check this file which contains a VBA solution: Book2 - RITA.xlsm
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  3. #3
    Registered User
    Join Date
    09-03-2013
    Location
    Reading
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: How to count 10 consecutive week days

    I just wanted to say this is a brilliant vba solution and works perfectly. thank you.

+ 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. Replies: 2
    Last Post: 07-25-2013, 01:01 PM
  2. [SOLVED] Count non-consecutive days as new occurence to be used in average
    By pjbassdc in forum Excel General
    Replies: 3
    Last Post: 02-21-2013, 01:08 PM
  3. Replies: 2
    Last Post: 11-05-2011, 07:29 AM
  4. Make Workday count 6 days in a week
    By BlastRanger in forum Excel General
    Replies: 6
    Last Post: 09-22-2010, 01:18 AM
  5. count consecutive negative days
    By pault22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2010, 08:10 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