Results 1 to 12 of 12

Need my attendance tracker to count consecutive days as one event instead of individually

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Need my attendance tracker to count consecutive days as one event instead of individually

    Our policy is, "if you are absent consecutive days, it’s considered one (1) incident."

    My tracker works for everything else, except it treats each absent as an incident. How can I make it only count 1 of consecutive days.
    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] Adjust attendance tracker to treat consecutive absences as a single.
    By taylorsm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2016, 09:11 AM
  2. Replies: 1
    Last Post: 03-09-2016, 01:05 PM
  3. Replies: 17
    Last Post: 08-03-2015, 06:15 AM
  4. [SOLVED] Count last 7 days of pupil attendance that exceeds 31
    By wilson23 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-30-2015, 10:11 AM
  5. Replies: 1
    Last Post: 10-24-2014, 09:57 PM
  6. Formula to look back 90 days and drop point on attendance tracker
    By tmorr24 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-22-2014, 01:27 AM
  7. [SOLVED] Listing consecutive days without inputting each one individually
    By jcrouse in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-08-2005, 11:06 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