+ Reply to Thread
Results 1 to 30 of 30

Count consecutive dates as one occurrence

Hybrid View

  1. 01-23-2017, 04:03 PM #1
    PietBom
    PietBom is offline
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Count consecutive dates as one occurrence

    Now I finalized it: The formula in N7 counts the Illness hours exceeding 40.
    The rest was already working to my opinion.
    I hope this is what you wanted.
    Attached Files Attached Files
    Kind regards,
    Piet Bom
    Reply With QuoteRegister To Reply
  2. 01-25-2017, 05:01 PM #2
    Bchez
    Bchez is offline
    Registered User
    Join Date
    01-09-2017
    Location
    Portland OR
    MS-Off Ver
    2013
    Posts
    14

    Re: Count consecutive dates as one occurrence

    Hi PietBom - Thank you for working so hard on this. What I actually need is the formula in G7. I think I have it now. Once again, many thanks for your excellent help!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to count consecutive dates for each employee from a listing of absence dates?
    By johnson3272 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-14-2024, 07:07 AM
  2. Count number of occurrence between dates
    By Wskip49 in forum Excel General
    Replies: 5
    Last Post: 09-14-2016, 03:06 PM
  3. [SOLVED] Count Consecutive Dates
    By Sasquatch2014 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-16-2016, 12:47 AM
  4. Count No. of occurrence of consecutive values
    By rvkadu1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-02-2013, 06:42 AM
  5. Count Occurrence of date (6th April) between two dates...
    By noonoogizmo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2012, 06:21 AM
  6. Count # Sick Day Occurrences based on dates and the Duration of each occurrence in hours
    By Elizabeth Bancroft in forum Excel General
    Replies: 12
    Last Post: 07-25-2012, 10:13 PM
  7. [SOLVED] Unable to count the occurrence of years in a list that contains dates and text
    By Gijs in forum Excel General
    Replies: 4
    Last Post: 03-29-2012, 09:01 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1