formular for max consecutive wins pr loss but with extra criteria {date} to filter the data

[MARTINSOMAC]

i use this formular for max consecutive wins/loss =ArrayFormula(MAX(FREQUENCY(IF(Backtest!Q:Q<0,ROW(Backtest!Q:Q)),IF(Backtest!Q:Q>=0,ROW(Backtest!Q:Q))))) but i need to filter this data based off date so i see my result for like only april or may , this date is dependent of another column where i put in the dates

 

[Kaper]

1) you are probably using Google Sheets. Please let us know. Because there is a lot of differences between excel and that product.
2) are your dates real excel/GoogleSheet dates? or just texts which look like a date. Easy way to check it is by changing formatting of the cell into General format. If you see the number like

45656

or similar, then you have real date, if you see still something looking as a date, then it is a text.