Results 1 to 12 of 12

How to count Monday and Friday as one occurance

Threaded View

  1. #1
    Registered User
    Join Date
    03-18-2014
    Location
    Calgary Canada
    MS-Off Ver
    Excel 2007
    Posts
    19

    How to count Monday and Friday as one occurance

    Hi,
    Below is my sample data set. Question: How many consequtive Fridays and Mondays did Chris W take in the data set below? The answer is 4.

    Criteria 1. Look at the Days column: Does Monday follow after Friday? If it does than count it, if it does not, don't count it.
    Criteria 2. Is there a separation of 2 days between Friday and Monday? If yes,then count it, if there is more than 2 days, don’t count it.

    Please see let me know if you could help me with this. I have also attached my sample spreadsheet. Thank you.

    Data Sample:
    Personnel Date Month Days
    Chris W 5/10/2013 May Fri
    Chris W 6/6/2013 Jun Thu
    Chris W 6/13/2013 Jun Thu
    Chris W 6/14/2013 Jun Fri
    Chris W 6/27/2013 Jun Thu
    Chris W 6/28/2013 Jun Fri
    Chris W 7/12/2013 Jul Fri
    Chris W 8/16/2013 Aug Fri
    Chris W 8/19/2013 Aug Mon
    Chris W 8/20/2013 Aug Tue
    Chris W 8/30/2013 Aug Fri
    Chris W 9/6/2013 Sep Fri
    Chris W 9/20/2013 Sep Fri
    Chris W 9/23/2013 Sep Mon
    Chris W 9/27/2013 Sep Fri
    Chris W 9/30/2013 Sep Mon
    Chris W 10/25/2013 Oct Fri
    Chris W 10/28/2013 Oct Mon
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count Holidays within Month, Within Monday - Friday
    By timharding in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-12-2013, 08:17 PM
  2. How to count all dates in column A using last friday and and next friday friday
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2011, 04:33 PM
  3. Use Ontime Only Monday through Friday
    By prescient in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2008, 07:35 PM
  4. Monday to Friday
    By lunar_star in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-09-2007, 12:22 AM
  5. Help change Friday to following Monday
    By David in forum Excel General
    Replies: 4
    Last Post: 06-21-2006, 08:30 PM

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