Results 1 to 30 of 30

Count consecutive dates as one occurrence

Threaded View

  1. #1
    Registered User
    Join Date
    01-09-2017
    Location
    Portland OR
    MS-Off Ver
    2013
    Posts
    14

    Count consecutive dates as one occurrence

    Hi - I have seen similar threads but none that cover what I am needing. I have a spreadsheet with a Calendar Tab that I enter data into to track Employee Illness occurrences. I have a Summary Tab that sums up all the info I need. The spreadsheet is configured to reset every 365 days. What I need is a formula in G7 on the Summary tab that would start when cell D7>40 as 1 occurrence and track subsequent occurrences of Employee Illness from the Calendar tab. The trick is that consecutive dates need to be treated as 1 occurrence. I have attached the spreadsheet with info on the Summary tab that I need. Thank you in advance. I have tried Sumif, Sumproduct. I think it's a simple IF/AND, but I can't get it to work.
    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. 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. Replies: 12
    Last Post: 07-25-2012, 10:13 PM
  7. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1