Selecting date intervalls

%3CLINGO-SUB%20id%3D%22lingo-sub-1566601%22%20slang%3D%22en-US%22%3ESelecting%20date%20intervalls%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566601%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-message-subject-wrapper%20lia-component-subject%20lia-component-message-view-widget-subject-with-options%22%3E%3CDIV%20class%3D%22MessageSubject%22%3E%3CDIV%20class%3D%22MessageSubjectIcons%20%22%3E%3CH1%20id%3D%22toc-hId-500727218%22%20id%3D%22toc-hId-500727255%22%20id%3D%22toc-hId-500727255%22%20id%3D%22toc-hId-500727218%22%3E%3CSPAN%20class%3D%22lia-message-read%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Foffice-365%2Ffiltering-date-intervalls%2Fm-p%2F1555461%22%20target%3D%22_blank%22%3EFiltering%20date%20intervalls%3C%2FA%3E%3C%2FSPAN%3E%3C%2FH1%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%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%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Etaking%20place%20in%20July%20to%20show%2C%20not%20those%20that%20span%20across%20July%26nbsp%3B%3CU%3EAND%3C%2FU%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eother%20months.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20around%20this%3F%20The%20date%20intervalls%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%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1566601%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1566636%22%20slang%3D%22en-US%22%3ERe%3A%20Selecting%20date%20intervalls%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566636%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F686578%22%20target%3D%22_blank%22%3E%40mhar985%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHard%20to%20tell%20unless%20you%20upload%20a%20sample%20file%20to%20visualize%20what%20exactly%20you%20are%20trying%20to%20achieve.%3C%2FP%3E%3CP%3EMaybe%20you%20can%20insert%20two%20helper%20columns%2C%20one%20having%20the%20start%20time%20interval%20and%20another%20having%20the%20end%20time%20interval%20and%20then%20you%20can%20filter%20your%20data%20based%20on%20the%20helper%20columns.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1566690%22%20slang%3D%22en-US%22%3ERe%3A%20Selecting%20date%20intervalls%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566690%22%20slang%3D%22en-US%22%3EHello%3CBR%20%2F%3E%3CBR%20%2F%3EFrom%20your%20question%2C%20you%20have%20dot%20(.)%20as%20your%20date%20separator%20-%2021.05.2020%20to%2010.10.2020.%20It's%20important%20that%20you%20have%20the%20same%20date%20separator%20on%20your%20system%20dot%20(.)%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20that's%20satisfied%2C%20you%20can%20click%20on%20the%20filter%20button%20in%20the%20column%20that%20contains%20date%20and%20filter%20what%20you%20want%3C%2FLINGO-BODY%3E
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 date intervalls in the column are exported from another sheet in the same workbook. 

 

Best, 

Mags

2 Replies

@mhar985 

Hard to tell unless you upload a sample file to visualize what exactly you are trying to achieve.

Maybe you can insert two helper columns, one having the start time interval and another having the end time interval and then you can filter your data based on the helper columns.

Hello

From your question, you have dot (.) as your date separator - 21.05.2020 to 10.10.2020. It's important that you have the same date separator on your system dot (.)

If that's satisfied, you can click on the filter button in the column that contains date and filter what you want