Closed Thread
Results 1 to 3 of 3

Count number of consecutive more than 3 days absent in a month

  1. 04-30-2017, 12:36 PM #1
    suchetherrah
    suchetherrah is offline
    Forum Contributor
    Join Date
    05-22-2015
    Location
    Malaysia
    MS-Off Ver
    MS365
    Posts
    197

    Count number of consecutive more than 3 days absent in a month

    Hi,

    Would like to identify the Teams did not attend (" ") count number times of >=3 consecutive days until today in a month
    Occurances start after "Y" until today's data which highlighted in color.

    I was looking at all the samples but still didn't get an idea on the count. Attached is the worksheet for your preview.

    Would really appreciate your advise. It will be a great anyone can advise.

    Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-30-2017, 12:49 PM #2
    cytop
    cytop is offline
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Count number of consecutive more than 3 days absent in a month

    Duplicate post: https://www.excelforum.com/excel-for...ml#post4642956
    https://www.excelforum.com/excel-for...ml#post4640524
    Reply With QuoteRegister To Reply
  3. 04-30-2017, 12:50 PM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,943

    Re: Count number of consecutive more than 3 days absent in a month

    Duplicate thread closed.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
Closed Thread
« 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 consecutive more than 3 days absent in a month/year exclude Sat/Sun/PubHol
    By suchetherrah in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-30-2017, 12:51 PM
  2. How to count number of consecutive days
    By dobracik in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-05-2016, 03:10 PM
  3. Count number of consecutive days by date
    By malek_ali7sas in forum Excel General
    Replies: 11
    Last Post: 02-21-2016, 10:17 AM
  4. 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
  5. [SOLVED] Count number days absent for different employees with multiple date ranges.
    By monkeypants in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-20-2015, 08:32 PM
  6. [SOLVED] Count number of consecutive days and instances
    By Cortlyn in forum Excel General
    Replies: 7
    Last Post: 02-06-2015, 06:02 PM
  7. [SOLVED] Count Consecutive Days Based on Unique Number
    By Kimston in forum Excel General
    Replies: 5
    Last Post: 11-23-2014, 04:46 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1