Results 1 to 21 of 21

Counting consecutive days worked

Threaded View

  1. #1
    Registered User
    Join Date
    09-16-2018
    Location
    Lake Charles, Louisianna
    MS-Off Ver
    2016
    Posts
    9

    Counting consecutive days worked

    I would appreciate greatly help with a formula to count consecutive days worked by an employee(no more than 13 consecutive days), BUT it also needs to reset count when employee misses a day. If possible, having formula dynamic and perform count from current date(which changes daily).. would be great.

    In attached sample, cells with start time are days worked, blank cells represent days not worked.

    Thank you
    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] Counting days worked
    By kbiro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-25-2016, 05:45 PM
  2. [SOLVED] Formatting of consecutive days worked
    By ktbb0312 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-23-2015, 05:46 PM
  3. Replies: 2
    Last Post: 11-05-2011, 07:29 AM
  4. Replies: 9
    Last Post: 09-03-2007, 08:26 PM
  5. [SOLVED] Counting the days worked in a month by employee
    By Curtis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-08-2005, 01:20 PM
  6. Counting te days worked in a month
    By Curtis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-07-2005, 01:10 PM
  7. [SOLVED] Counting days worked
    By anonymous person in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-22-2005, 04:06 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