+ Reply to Thread
Results 1 to 2 of 2

Counting instances with criteria but if dates are sequential count as one

  1. #1
    Registered User
    Join Date
    07-14-2021
    Location
    Seattle, Washington, USA
    MS-Off Ver
    2016
    Posts
    1

    Counting instances with criteria but if dates are sequential count as one

    I have a table that I am trying to have a column that counts the number of instances someone is out of the office. However, if the dates are sequential excluding weekends and federal holidays, to count as one instance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,945

    Re: Counting instances with criteria but if dates are sequential count as one

    Use a column of formulas to identify blocks of dates, as in the attached. You need to list your holidays in the holidays area highlighted on the sheet.
    Attached Files Attached Files
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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] Counting instances with 2 criteria.
    By dscheeringa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-01-2012, 11:08 AM
  2. Counting the instances of months in a range of dates
    By montek in forum Excel General
    Replies: 4
    Last Post: 12-25-2011, 12:10 PM
  3. Counting number of sequential dates
    By rooshio in forum Excel General
    Replies: 5
    Last Post: 11-05-2009, 09:11 PM
  4. [SOLVED] A counting formula that won't count multiple instances of same val
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] A counting formula that won't count multiple instances of same val
    By Watercolor artist in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. A counting formula that won't count multiple instances of same val
    By Watercolor artist in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. A counting formula that won't count multiple instances of same val
    By Watercolor artist in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. [SOLVED] A counting formula that won't count multiple instances of same val
    By Watercolor artist in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-14-2005, 11:05 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