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, 10 views)

Would it be easiest enough to just use conditional formatting in K5 to identify anything less than 365 days?

Conditional Formatting

• Highlight applicable range >> K5:K100
• Home Tab >> Styles >> Conditional Formatting
• New Rule >> Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =$K6-$N$2<365
• Format… [Number, Font, Border, Fill]
• OK >> OK

Thank you so much jeffreybrown