Filtering date intervalls

%3CLINGO-SUB%20id%3D%22lingo-sub-1555461%22%20slang%3D%22en-US%22%3EFiltering%20date%20intervalls%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555461%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20column%20with%20a%20header%20that%20contains%20date%20intervalls%20for%20project%20activities%20(e.g.%2021.05.2020%20-%2010.10.2020).%20In%20the%20header%20I%20would%20like%20to%20filter%20only%20activities%20that%20are%20valid%20within%20a%20spesific%20time%20period%20(e.g.%20July%202020).%20The%20problem%20is%20that%20the%20filter%20function%20in%20the%20drop%20down%20menu%20only%20allows%20for%20activities%26nbsp%3B%3CU%3EONLY%3C%2FU%3E%20taking%20place%20in%20July%20to%20show%2C%20not%20those%20that%20span%20across%20July%26nbsp%3B%3CU%3EAND%3C%2FU%3E%20other%20months.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20around%20this%3F%20The%20dates%20in%20the%20column%20are%20exported%20from%20another%20sheet%20in%20the%20same%20workbook.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%26nbsp%3B%3C%2FP%3E%3CP%3EMags%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1555461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Problem%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hi, 

 

I have a column with a header that contains date intervalls for project activities (e.g. 21.05.2020 - 10.10.2020). In the header I would like to filter only activities that are valid within a spesific time period (e.g. July 2020). The problem is that the filter function in the drop down menu only allows for activities ONLY taking place in July to show, not those that span across July AND other months.

 

Is there any way around this? The dates in the column are exported from another sheet in the same workbook. 

 

Best, 

Mags

0 Replies