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
Bookmarks