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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies