Formula for dates that fall in a certain period ( between two dates)

[aledebortoli]

Glad I was able to help!

Hi Everyone,
I hope you can help me.
I have created a booking calendar in vba and I have used a filter for the calendar that shows dme just the bookings between two dates.

Here is my question:
If I want to see all the bookings from 1st to 31st December the filter does not show me the bookings I have that are included in that period (for example from 24th November to 5th January).
Actually the formula is:
i.e. >= E12 and <= E42

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

Thanks and happy new year!

 

[Joe4]

I had already moved your question to its own thread (Filter between 2 dates)
Please work in that other thread, as I am locking this one.