+ Reply to Thread
Results 1 to 3 of 3

Display tasks planned for current week

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Display tasks planned for current week

    Hi, I have a formula which returns tasks which are planned for coming week from list. Thanks to Bo_Ry for his help in providing such a great formula:
    =IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW(C$2:C$36)/(ABS(TODAY()-WEEKDAY(TODAY(),2)+10-$D$2:$D$36)<4),ROWS(J$10:J10))),"")

    I want to a little amended to give me tasks which are planned for current week please

    Attached is workbook with expected results highlighted

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Display tasks planned for current week

    Perhaps the only change you need is

    =IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW(C$2:C$36)/(ABS(TODAY()-WEEKDAY(TODAY(),2)+3-$D$2:$D$36)<4),ROWS(J$10:J10))),"")
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Re: Display tasks planned for current week

    Great this works. +1 rep

    Thank you

+ 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] Display tasks planned for coming week
    By Zahid0111 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-20-2021, 07:27 AM
  2. [SOLVED] Set PivotTable Filter to Current Day, Current Week, Current Month, or Current Year
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2014, 08:31 AM
  3. [SOLVED] Display the first day of the current week in a cell. Updates via a macro button
    By jclark4321 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2013, 06:51 PM
  4. Display Current Week # according to range.
    By lxa8888 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-25-2012, 05:20 PM
  5. Display Current Week in Excell
    By RR01 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2012, 03:17 AM
  6. [SOLVED] Looking for Fomula to display week in Current Quarter
    By Cra5h in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-13-2012, 03:21 PM
  7. Replies: 4
    Last Post: 03-21-2011, 05:37 PM

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