Need All Dates Between Two Dates Power Query Has the Answer!
Power Query Generate Dates Between Two Dates
Download the file:
https://docs.google.com/spreadsheets/...
In this Power Query tutorial, you’ll learn how to generate a full list of dates between a Start Date and an End Date.
We take a simple table with two dates and convert it into daily rows — one row per day.
You’ll see two different methods:
A quick Number Range trick using date serial values
A clean and readable List.Dates function
Both methods solve the same problem, but they teach different ways of thinking in Power Query.
This is especially useful for:
Calendar tables
Attendance and leave tracking
Subscription periods
Project timelines
Any scenario where you need daily breakdowns
By the end, you’ll understand not just how to generate dates, but why each method works.
Resources Mentioned:
🔗 Power Query Challenges Playlist:
• Power Query: Challenges
🎥 Dynamic Array Formulas Playlist:
• Modern Excel Challenges
🎥 Power Query: Tip & Tricks:
• Power Query: Tip & Tricks
🔔 Subscribe for More Tutorials:
/ @howtolearnexcel
#PowerQuery #ExcelTips #HowToLearnExcel