Filter between 2 dates

[aledebortoli]

You are welcome.
Glad I was able to help!

Hi Joe,
Sorry for disturbing you but I have more or less the same issue.
I hope you can help me. I created a booking calendar in vba and applied a filter to the calendar to only display bookings for the dates of the requested period in the calendar.
If, for example, in the calendar I want to see all the bookings from 1st to 31st December the filter does not show me the bookings I have between those dates (for example from 24th November to 5th January) because I currently have an incorrect formula

i.e. >= December 1st and <= December 31st

I can't find the right formula that shows me the bookings excluded from the formula but that fall within that period, for example from 24 November to 5 January.
Hope it's clear

Thank you Alex

 

[Joe4]

Welcome to the Board!

Your question is not quite the same as the one you had posted this question to, so I have split it into its own question (split from: VBA: check date between 2 dates). It is typically better to post your questions to new threads instead of posting on to someone else's old thread. It will also then show up in the Unanswered Threads listing that many people use to look for new questions to answer.

The new FILTER function available in Excel 365 should make what you want to do pretty easy. See here for instructions: Filter data between dates

 

[aledebortoli]

Welcome to the Board!

Your question is not quite the same as the one you had posted this question to, so I have split it into its own question (split from: VBA: check date between 2 dates). It is typically better to post your questions to new threads instead of posting on to someone else's old thread. It will also then show up in the Unanswered Threads listing that many people use to look for new questions to answer.

The new FILTER function available in Excel 365 should make what you want to do pretty easy. See here for instructions: Filter data between dates

Thanks a lot for your welcome and for the link. I have already used it as for instructions but I can't find a solution when a booking is i.e. from 24th November to 5th January.
How can I show it if I use the filter data between two dates? It doesn't come out.

 

[Joe4]

Are you sure that your dates are entered as dates, and not as text?

Can you please post a sampling of the data you are running this against, so we can see how it is structured, and post the formula you are trying?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[aledebortoli]

Hi Joe,
First of all Happy New Year !!
I download and install XL2BB Add-in but, when I tried to copied the mini range, Excel stopped working. I don't know why.
So I'm posting some pictures. On pictures 2 and 3 the formulas I'm using and, on the first picture, the cell the second picture is referring to

 

[Joe4]

Can you show us a before/after image of an example?
First, show us the data as it first appears.
Then, show us an image of what you want your expected results to look like.