+ Reply to Thread
Results 1 to 4 of 4

Count difference between dates for this week values only

  1. #1
    Registered User
    Join Date
    12-29-2020
    Location
    Krakoˇw, Poland
    MS-Off Ver
    365
    Posts
    2

    Count difference between dates for this week values only

    Hello,

    I have a column D containing all the Dates, and I would like to show the count of missed days for THIS WEEK values only from all the entries in column D.
    In other words, if there is a difference between two Dates in column D and it occured this week, I would like to count it.

    I have below formula to calculate "Total days missed" between first and the last entry in Dates column D, however I can't adopt this formula to display "Days Missed" for this week entries only.

    Please Login or Register  to view this content.
    Sample file attached.

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-15-2020
    Location
    malaysia
    MS-Off Ver
    office2007
    Posts
    518

    Re: Count difference between dates for this week values only

    B3 cell , array formula

    HTML Code: 
    =TEXTJOIN(",",,TEXT(IF(COUNTIF($D$7:$D$500,(MIN($D$7:$D$500)-1)+ROW(INDIRECT("1:"&(MAX(DAY($D$7:$D$500))))))>0,"",(MIN($D$7:$D$500)-1)+ROW(INDIRECT("1:"&(MAX(DAY($D$7:$D$500)))))),"YYYY/M/DD"))

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,199

    Re: Count difference between dates for this week values only

    Non array formula solution:
    In B2:
    Please Login or Register  to view this content.
    B3:
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    12-29-2020
    Location
    Krakoˇw, Poland
    MS-Off Ver
    365
    Posts
    2

    Re: Count difference between dates for this week values only

    Quote Originally Posted by bebo021999 View Post
    Non array formula solution:
    In B2:
    Please Login or Register  to view this content.
    B3:
    Please Login or Register  to view this content.
    Thank you so much for your help!

    I end up using this code as final.

    Total days missed:
    Please Login or Register  to view this content.
    Days missed this week:
    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 dates in a row within a specific week.
    By Wijnand1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2018, 10:22 AM
  2. [SOLVED] Count dates last week, Mon-Fri
    By bsl13 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-25-2018, 11:41 AM
  3. Replies: 5
    Last Post: 03-27-2015, 08:07 AM
  4. Show Values as % Difference -- Quickly Change From Month to Week
    By kestefon in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-18-2013, 06:40 AM
  5. Difference between two dates in week and days
    By newbiekinsey in forum Excel General
    Replies: 8
    Last Post: 06-06-2011, 06:02 PM
  6. Count Difference between two dates
    By Clash in forum Excel General
    Replies: 4
    Last Post: 05-03-2006, 04:50 AM
  7. need to convert list of dates to count no. of dates by week
    By neowok in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-30-2006, 11:54 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