Hey Guys , Lets learn how to generate a list of dates between two dates.
Imagine you have the specific starting date and the ending date, you may need to list all the dates between these two given dates in Excel.
Or you want to get a list of dates when an employee was on leave.

Now this tutorial is talking about the methods to list all dates between two dates in Excel without using VBA or Macros but using new functions like SEQUENCE and TEXTJOIN.

You can download the file from the link below
https://bit.ly/3uhCWk4

Video Index
00:00 Intro
00:25 SEQUENCE Function
01:38 Generate List of Dates
03:13 TEXTJOIN Function:- Combine in 1 Cell/Column
03:51 TEXT Function:- Format as Date Before Joining
04:57 Outro




Also, check these videos if you want to learn more

1 Min Excel: If you enjoy short videos check this section
   • Shorts : Random  

Excel: Check this playlist for Excel-related things
   • Excel  

Keyboard Shortcuts: Check this section to save some time in everyday excel work
   • Excel Keyboard Shortcuts  

Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports
   • Pivot Tables  

Power Query: Check the Power Query playlist for Data Preparation & its Automation
   • Power Query  

Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations
   • Power BI  



Please subscribe to our channel and Follow us on other social media platforms for regular updates :

Tiktok https://vm.tiktok.com/ZSH28XEt/
Facebook   / datacense  
Twitter   / datacense  
LinkedIn   / datacense  
Instagram   / data.cense