hello everyone.
I want fix this formula to find who less Days 365 (less than one year)
from list in table K5

=IFERROR(INDEX($B$6:$B$2220;SMALL(IF(YEAR($N$2)=YE AR($J$6:$J$2220)*(MONTH($N$2)=MONTH($J$6:$J$2220)) ;ROW(B$6:B$2220)-5;"");ROW()-5));"")

all help will be appreciated
Thank you

Attached Files

test.xlsx (12.4 KB, 12 views)