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/d/1BAUsqH0Em4Gs7DYILlieP1DZMlxw1MWp?rtpof=true&usp=drive_fs

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:
https://www.youtube.com/playlist?list=PLDmmlQOC_xTW0FbOs6JrIaKhUFZbXbcfa
🎥 Dynamic Array Formulas Playlist:
https://www.youtube.com/playlist?list=PLDmmlQOC_xTVqF4T-6bLaEjRGpZP8CnZC
🎥 Power Query: Tip & Tricks:
https://www.youtube.com/playlist?list=PLDmmlQOC_xTXuPpSzopxiOB-5Nj8ICePI

🔔 Subscribe for More Tutorials:
https://www.youtube.com/@howtolearnexcel?sub_confirmation=1

#PowerQuery #ExcelTips #HowToLearnExcel

Видео Need All Dates Between Two Dates Power Query Has the Answer! канала How to Learn Excel