Excel AutoFilter for Date Range Two Ways

[@osoriomatucurane9511]

Awesome tutorial, thank you for the concept of dynamic dates (YTD, previous month, previous year,....).
It would be great you had a date picker there.
A great trick I have just learnt to apply the filter, once u defined the rule, just right click and select filter by color, instead of the filter drop down list and box

[@DougHExcel]

Neat use of conditional formatting!

[@contextures]

Thanks, Doug!

[@Chef-1707]

I love all your videos and your soothing voice teaches in an easy to follow, well explained way . Appreciate you sharing your knowledge

[@contextures]

Thank you so much!

[@eryckgaming6047]

Thank you, this is a simpler idea than what I was over thinking

[@contextures]

You're welcome, Eryck, and thanks for your comment!

[@wayneedmondson1065]

Hi Debra.. great tips.. thanks for the video. Here is another one.. use Advanced Filter to Filter By Formula. So, take the formula you created for the conditional formatting and put it in cell I2: =AND(B4>=$G$2,B4

[@contextures]

Thanks, Wayne, and I've been a big fan of Advanced Filters for many years! You can see some of my criteria formulas (and a couple of my older videos) here: www.contextures.com/xladvfilter02.html

[@DweensFantasy]

What if i want to exclude some dates between the start and end dates that I selected?

[@Larwai]

It's wondeerful!

[@contextures]

Thank you!

[@insafkhan873]

Your the best , thank you

[@contextures]

Aw, thank you, Insaf! 😊

[@Mrjobsman]

YOU ARE THE BEST

[@bayarmaamunkhbat8876]

Your best, thank you

[@contextures]

You're welcome, Bayarmaa, and thanks for your comment!

[@mohammadsadrzadeh4067]

How can I use Slicers to Filter Data Betweeen Two Dates in Excel ?

[@contextures]

Add a new column in the data, with a formula that checks if date is in date range. Then, add a slicer for that column, and filter for TRUE

[@mohammadsadrzadeh4067]

@@contextures Thanks but hard for me to visulaize. Could you please share a screenshot or template?

[@osoriomatucurane9511]

Slicing between periods, month, quarters, semester and year.
Create aditional columns for those periods.
Month = text(date, "mmm")
Quarters = ifs(date

[@Yasin45]

Effective video

[@contextures]

Thank you!

[@Matawfik]

Thank you

[@rosh_unb3944]

Great video have been banging my head for a while about this. But how to do when you have date and time in two different cell and you want to apply this filter formula?

[@yashavantpatel8771]

Good illustration.
Can we do this with advance filter?

[@rahulsingh3176]

Thanks you mam

[@contextures]

You're welcome, Rahul, and thanks for your comment!

[@qqui5770]

Hep me value grand total pivot tab not match when the creat fieds .

[@kashrafali2258]

HERE, CAN WE SEE THE RESULT AS SOON AS WE CHANGE THE DATE AND WITHOUT REFERESHING

[@contextures]

Thanks for your question, and the AutoFilter does not automatically refresh.

[@t.s6919]

How this sales data table create

[@contextures]

This video shows how to make a formatted table:
ruclips.net/video/AM7iUCYSUrw/видео.html