Sequence Function: Create Sequential List of Dates, Weekdays & Months in Excel with Best Examples

preview_player
Показать описание
There are 3 ways to create sequential lists in excel (Control Drag, Fill Series & Sequence Function). All of them are great but Sequence function provides the added advantage of being more user friendly and makes it easier to edit your list, if needed. Also, its a latest function and you must learn it. Lets cover two examples, where we will learn how to combine Sequence Function with other functions like Filter Function, Date & Weekday Function & a hidden excel function.

Link to download file:
Рекомендации по теме
Комментарии
Автор

First! I am new to using sequence, and it is a great function.

qward
Автор

Great 👍🏼. Is there a way to apply the same concept and eliminate FRIDAYS from days between tow dated ?!

abdullahquhtani
Автор

Can we get sequence of quarter date between two input dates? i.e., If I put 15 Jan. 2024 and 15 Dec. 2024 then it suppose to display 15 Jan. 2024, 15 Mar. 2024, 15 June, 2024, 15 Sep. 2024 and 15 Dec. 2024.
Thanks in advance

SKidharsan_SManodheedan