Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

Discover how to effectively filter records between two dates using Excel formulas in this engaging tutorial. Perfect for Excel users with Office 365, this video guides you step-by-step to create dynamic, user-friendly reports.

⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/records-between-dates

Key Highlights:
- Dynamic Filtering: Learn to use Excel's filter feature dynamically, where changing dates automatically updates your report.
- Drop-Down Creation: Master creating 'from' and 'to' date drop-downs, with the 'to date' displaying only dates after the selected 'from date'.
- Data Preparation: Understand how to prepare a unique list of dates for your drop-downs using Excel's dynamic array functions like UNIQUE and SORT.
- Data Validation: Dive into crafting data validation drop-down lists with new dynamic array functions, ensuring a user-friendly interface.
- Advanced Filtering: Excel at using the FILTER function for sophisticated data analysis, including handling multiple criteria and understanding the logic behind Excel formulas.
- Dynamic Arrays Application: Witness the power of dynamic arrays in action as you modify your data set and watch your report update automatically.

Tutorial Summary:
This video shows a practical example of using Excel's new Dynamic array functions to create a report that shows all records that fall between two dates. You learn:
1. How to use Dynamic array (# hash referencing) in data validation
2. How to create an Excel dependent drop down list
3. Create a FROM and TO Date drop down list where the TO date occurs AFTER the from date
4. Use the new Dynamic array SORT and UNIQUE functions
5. Use the new Excel Dynamic array Filter function (new Excel lookup formula) to return multiple match results
6. How to do an AND logical test with the Filter formula to return all values between two dates.

This is a knowledge packed tutorial covering the different aspects of dynamic arrays and Excel's new calculation engine.

LINK to Advanced Filter Feature: https://youtu.be/VqQACB_69SQ
LINK to dynamic array playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP

My Online Excel Courses ► https://www.xelplus.com/courses/

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel