Results 1 to 13 of 13

Count Consecutive Days of Absence Per Staff

Threaded View

shenggay18 Count Consecutive Days of... 12-24-2020, 07:13 AM
AliGW Re: Count Consecutive Days of... 12-24-2020, 07:25 AM
shenggay18 Re: Count Consecutive Days of... 12-24-2020, 07:33 AM
kvsrinivasamurthy Re: Count Consecutive Days of... 12-24-2020, 08:03 AM
shenggay18 Re: Count Consecutive Days of... 12-24-2020, 08:39 AM
FlameRetired Re: Count Consecutive Days of... 12-24-2020, 05:36 PM
shenggay18 Re: Count Consecutive Days of... 12-24-2020, 10:43 PM
bebo021999 Re: Count Consecutive Days of... 12-24-2020, 10:12 PM
kvsrinivasamurthy Re: Count Consecutive Days of... 12-27-2020, 04:49 AM
kvsrinivasamurthy Re: Count Consecutive Days of... 12-27-2020, 05:32 AM
shenggay18 Re: Count Consecutive Days of... 12-27-2020, 06:02 AM
Glenn Kennedy Re: Count Consecutive Days of... 12-27-2020, 05:41 AM
kvsrinivasamurthy Re: Count Consecutive Days of... 12-27-2020, 05:57 AM
  1. 12-24-2020, 07:33 AM #3
    shenggay18 is offline
    Registered User
    Join Date
    12-24-2020
    Location
    singapore
    MS-Off Ver
    enterprise
    Posts
    5

    Re: Count Consecutive Days of Absence Per Staff

    Quote Originally Posted by shenggay18 View Post
    Can you please help me? What i want to do is indicate a Y or N on the 3rd column, if the date on the 2nd column is consecutive for the staff. On the 4th column, id like to know how many days is the duration of the consecutive dates.

    Attachment 710248
    attaching excel file.
    Attached Files Attached Files
    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. 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 Consecutive Occurrences of Absence including weekends
    By Polymorph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2021, 05:23 PM
  3. [SOLVED] Staff Absence Tracker - showing number of days and number of occasions
    By chergar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-15-2020, 04:14 AM
  4. [SOLVED] Count days falling within given period (with criteria)(absence tracker)
    By annazet in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2020, 05:04 AM
  5. [SOLVED] Count Consecutive & Non consecutive days per given logic
    By asimraza89 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-26-2019, 04:31 PM
  6. Consecutive days count with multiple staff
    By 01271676 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-19-2019, 03:01 AM
  7. Multiple Days Hourly staff count
    By aehartle in forum Excel General
    Replies: 14
    Last Post: 05-19-2010, 11:42 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