Uploaded December 2023 | Updated September 2026, 2 weeks ago

---

In our Data to Decision series, this video is for creating a continuous series of dates in Excel, a key skill needed for anyone involved in planning, scheduling, or tracking events.

Watch along to learn how to create a continuous series of dates when/if:

1:12 A starting date and the number of days are given.
2:26 For a dynamically given year create all the dates in that year.
4:55 If a dynamic month is given, generate all the dates in that month.

Creating a continuous sequence of dates has a broad spectrum of uses:
** Leave Trackers: To track, and plan leaves of your team
** Content Calendars: Plan out publication dates for content marketing.
** Event Planning: Keep track of event dates throughout the year.

Check our detailed blog posts on our Data to Decisions page:
indzara.com/generate-all-the-dates-of-a-month-in-excel
indzara.com/how-to-generate-all-the-dates-of-a-year-in-excel

To explore our fast-growing collection of free Excel tutorials covering a wide array of topics, please visit: indzara.com/datatodecisions

#exceltips #excelmadeeasy #exceltutorials