Results 1 to 5 of 5

Count Instances off Absenses

Threaded View

  1. #1
    Registered User
    Join Date
    01-14-2025
    Location
    Fife
    MS-Off Ver
    365
    Posts
    2

    Count Instances off Absenses

    I need a formula to count instances off Absence over the last year.
    I.e. 1 day off is 1 absence, 4 days is 1 instance, 20 days is 1 instance etc etc.
    Been trying to do it with the Weekday function but the problem is that only a 4 day week is worked so the Friday does not join up instances over subsequent weeks.
    The dates are in Column E and the formulas I have tried and failed with are in K2

    Thanks in advance.
    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. Count Instances
    By gishena in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2016, 03:59 AM
  2. Count of instances
    By Walter18 in forum Excel General
    Replies: 3
    Last Post: 04-02-2016, 04:56 PM
  3. [SOLVED] Count # of Instances the Name Appear then the # of Day between the occurences
    By bhenlee in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-21-2015, 05:34 PM
  4. count instances within row
    By vicktown in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2009, 03:42 AM
  5. Count number of instances of an act. #
    By walke2jd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2007, 11:34 AM
  6. Count unique instances
    By meweaver27 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-28-2007, 09:57 AM
  7. [SOLVED] Count Instances
    By Ken in forum Excel General
    Replies: 2
    Last Post: 04-01-2005, 08: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