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]
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