Home

Filter information depending on the dates

%3CLINGO-SUB%20id%3D%22lingo-sub-804398%22%20slang%3D%22en-US%22%3EFilter%20information%20depending%20on%20the%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804398%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20I%20am%20wondering%20if%20it%20is%20possible%20to%20filter%20information%20with%20dates%2C%20but%20not%20the%20same%20as%20usual%20filter%20that%20you%20have%20in%20Excel%20with%20dropdown%20menu.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20HAVE%20data%20base%20where%20there%20are%20a%20lot%20of%20values%20for%20different%20dates%2C%20the%20dates%20are%20repited%20for%20each%20unit%20that%20we%20have%20(touristic%20apartments%20names%2Foccupancy%2Fprices%2Fdates).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20NEED%20take%20a%20different%20dates%20and%20need%20to%20see%20data%20just%20for%20this%20time%20frame.%20As%20you%20can%20see%20at%20photo%2C%20I%20put%2018%2F8%20and%20the%20last%20day%20when%20I%20want%20to%20see%20all%20data%20between%2018%20and%26nbsp%3B%2021%20of%20Aug.%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20than%20if%20I%20want%20to%20change%20day%26nbsp%3B%20to%20any%20other%20day%20(for%20example%20from%2017of%20Oct%20to%2028%20of%20Dic)%2C%20the%20data%20should%20be%20shown%20automaticly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20do%20in%20Excel%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20835px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126945iD26FFB9F36B8744E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EKind%20Regards%20for%20any%20help%2C%26nbsp%3B%3C%2FP%3E%3CP%3ENelly%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-804398%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-804434%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20information%20depending%20on%20the%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804434%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F298559%22%20target%3D%22_blank%22%3E%40NellyYakunina%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20if%20with%20VBA%20programming.%3C%2FP%3E%0A%3CP%3EAbout%20manual%20filtering%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcelribbon.tips.net%2FT012918_Filtering_Columns%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelribbon.tips.net%2FT012918_Filtering_Columns%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
NellyYakunina
New Contributor

Hi everyone, I am wondering if it is possible to filter information with dates, but not the same as usual filter that you have in Excel with dropdown menu. 

 

I HAVE data base where there are a lot of values for different dates, the dates are repited for each unit that we have (touristic apartments names/occupancy/prices/dates). 

 

I NEED take a different dates and need to see data just for this time frame. As you can see at photo, I put 18/8 and the last day when I want to see all data between 18 and  21 of Aug. 

And than if I want to change day  to any other day (for example from 17of Oct to 28 of Dic), the data should be shown automaticly.

 

Is it possible to do in Excel? 

clipboard_image_0.png

Kind Regards for any help, 

Nelly 

1 Reply

@NellyYakunina 

That's if with VBA programming.

About manual filtering is here https://excelribbon.tips.net/T012918_Filtering_Columns