Generate List of Dates between two Dates in Excel | Non VBA Method | SEQUENCE Functions
HTML-код
- Опубликовано: 25 июл 2024
- 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
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 vm.tiktok.com/ZSH28XEt/
Facebook / datacense
Twitter / datacense
LinkedIn / datacense
Instagram / data.cense Наука
Hi. I need to ctreate a sepreadsheet with 5 rows per workday. Any ideas how to do that?
Is it possible to create the list but in columns?
How to reverse work of this method?? Like if I have multiple dates in and grouping them in (1-Jan -2022 to 5-jan-2022), (8-jan-2022 to 12-jan-2022)
what would be the basis of groups. i can see jan itself has 2 groups.. how to know which dates belong to a group. 4 days 5 days or any other logic
@@datacense for example in one column I have all dates in sequence and in other column I have values with respect to dates (in the values some has greater than zero and some has only 0) ..
So I want to group the dates in manner that let's say (05-04-2021 to 10-04-2021) has (1,2,3,4,5) I.e 5 number
and (11-04-2021 to 13-04-2021) has (0,0,0) I.e. 3 number
Again (14-04-2021 to 20-04-2021) has (56,57,58,10,60,75,80) has 6 values
Again (21-04-2021 to 30-04-2021) has (0,0,0,0,0,0,0,0,0,0) has 10 values..
I have very big data and I have to group in this manner.. Is there in trick to solve it. Could you help me to sort this issue..?
@@abrarhaware3007 we can think on this please mail your sample data to support@datacense.com
I have one question how do you decide first group will have 5 entries second have 3 and third have 6 entries. Is there a logic to that
@@datacense ok.. I will send you and explain same in sheet only