Results 1 to 12 of 12

Count number of consecutive days by date

Threaded View

  1. 02-20-2016, 07:23 AM #1
    malek_ali7sas
    malek_ali7sas is offline
    Registered User
    Join Date
    02-27-2013
    Location
    ksa
    MS-Off Ver
    Excel 365
    Posts
    6

    Count number of consecutive days by date

    dear all

    please i need your help to know the formula for the attached file

    the file mention the worksheet for the employees

    if the employee absent from 1 to 3 consecutive days its mean that absent 1 time

    please i want to know how it make by formula because i have more than 500 employees

    please help me
    Attached Files Attached Files
    Last edited by malek_ali7sas; 02-20-2016 at 07:37 AM.
    Reply With QuoteRegister To Reply
« 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. Count number of consecutive days and max streak
    By caubetiep1337 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2016, 03:53 AM
  2. Count Consecutive Days while bridging over days off and holidays
    By chad479 in forum Excel General
    Replies: 17
    Last Post: 08-03-2015, 06:15 AM
  3. Count Consecutive Days from Today's Date
    By sinspawn56 in forum Excel General
    Replies: 6
    Last Post: 04-24-2015, 06:39 PM
  4. [SOLVED] Count number of consecutive days and instances
    By Cortlyn in forum Excel General
    Replies: 7
    Last Post: 02-06-2015, 06:02 PM
  5. [SOLVED] Count Consecutive Days Based on Unique Number
    By Kimston in forum Excel General
    Replies: 5
    Last Post: 11-23-2014, 04:46 PM
  6. Count Consecutive Empty Cells and Delete non-blank cells by specified number of days.
    By swhennen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2013, 01:01 PM
  7. Excel 2007 : Count the number of consecutive days worked and highlight
    By Deborah Martin in forum Excel General
    Replies: 2
    Last Post: 11-05-2011, 07:29 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1