+ Reply to Thread
Results 1 to 2 of 2

Formula to count the number of consecutive days

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    Manchester, England
    MS-Off Ver
    Excel 365
    Posts
    36

    Formula to count the number of consecutive days

    Column A has a long list of dates. Some are consecutive days, some are not.

    What I want is for column B to show is if that date is part of a consecutive sequence, the number of days that are in that sequence.

    For example:

    A B
    13/02/2023 1
    15/02/2023 2
    16/02/2023 2
    18/02/2023 3
    19/02/2023 3
    20/02/2023 3
    22/02/2023 1
    24/02/2023 2
    25/02/2023 2

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Formula to count the number of consecutive days

    with Power Query

    Date Count
    13/02/2023
    1
    15/02/2023
    2
    16/02/2023
    2
    18/02/2023
    3
    19/02/2023
    3
    20/02/2023
    3
    22/02/2023
    1
    24/02/2023
    2
    25/02/2023
    2


    Please Login or Register  to view this content.

+ 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. Count number of consecutive more than 3 days absent in a month
    By suchetherrah in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-30-2017, 12:50 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 of consecutive days and instances
    By Cortlyn in forum Excel General
    Replies: 7
    Last Post: 02-06-2015, 06:02 PM
  6. [SOLVED] Count Consecutive Days Based on Unique Number
    By Kimston in forum Excel General
    Replies: 5
    Last Post: 11-23-2014, 04:46 PM
  7. Replies: 2
    Last Post: 11-05-2011, 07:29 AM

Tags for this Thread

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