Date Range (Help)

[Remi_BILLARS]

Hi all,

I need your help because I tried everything … and I spent hours there.

I need to sort the data according to a date period.

I have a DATA sheet, a FILTER sheet with 2 columns “Date Start” and “Date End”.

In Filter sheet I created a virtual column and I tried to put:

SELECT (DATA [_ROWNUMBER], [Date]> [_THISROW]. [Date Start], [Date] <[_THISROW]. [Date End]

THEN

SELECT (DATA [_ROWNUMBER], [Date]> (FILTER [Date Start], Date] <(FILTER [Date End]

The first only takes into account the “DATE START” BUT DO NOT TAKE INTO ACCOUNT THE “DATE END”.

Thank you for helping me. I really can’t do it.

thank you so much