+ Reply to Thread
Results 1 to 2 of 2

Counting work occurrences for attendance

  1. #1
    Registered User
    Join Date
    09-13-2012
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Counting work occurrences for attendance

    Currently, I am working on a spreadsheet where I need to track employee occurrences for attendance. If an employee is absent, they obtain 1 occurrence. This 1 occurrence allows them to be absent three consecutive work days. If they are absent for the 4th concecutive day, they obtain an additional occurrence and are allowed an additional three work days they can be absent before obtaining another occurrence. Since an employee can work 4 day or 5 day weeks, I'm having difficulty finding a formula that would calculate this. Any help would be much appreciated.

  2. #2
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Counting work occurrences for attendance

    daneff ..
    provide a sample non-sensetive workbook ...
    it will help us to understand your problem..

    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] counting occurrences
    By kri54sub in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2013, 01:01 PM
  2. Comparing attendance occurrences with rolling periods
    By amybrown in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-07-2012, 01:19 AM
  3. Counting occurrences
    By HaydenB in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-30-2010, 04:26 PM
  4. Counting occurrences of two conditions
    By mfernandes in forum Excel General
    Replies: 2
    Last Post: 10-01-2010, 03:19 PM
  5. Counting number occurrences
    By thermometer in forum Excel General
    Replies: 3
    Last Post: 06-06-2006, 03:10 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