List All the Dates, Workday or Weekend ONLY dates between two dates in Excel using Formula

✅ Download your FREE Excel Core Book: https://learnexceltoexcel.com/free-excel-core-book/ Learn how to get a list of dates between two dates, Workdays or Weekend only dates using dynamic formula in Excel. With dynamic array functions, we can write formulas that help us get list of dates between two dates really easily. *[[ Download Practice Workbook ]]* Join Excel Maven Program *EMP* to download the practice workbook for this tutorial: https://learnexceltoexcel.com/subscribe/ File: 0206 List All dates between dates.xlsx 00:00 Intro 00:11 1. List All the dates between dates using Formula 1:04 2. List Workdays only between dates using Formula 1:42 2a. Understanding WEEKDAY Function 2:11 2b. Using WEEKDAY function as criteria to get Workdays 3:00 2c. Using FILTER Function to extract Workdays from Weekdays 3:47 2d. Finalizing Workday Formula without helper column 5:00 2e. Using LET Function to write better Workday List Formula 6:49 List Weekends only between dates using Formula