Category: Date Transformation

With a single formula, you'll learn to create a dynamic monthly calendar instantly in Excel through this post
Learn to generate the first Sunday that occurs on the first week of a month with simple Excel formulas through
Using Excel's simple yet powerful functions like WEEKDAY, SEQUENCE and FILTER, learn how to skip weekends and generate only working
Learn to generate a specific weekday of a week using simple Excel functions like WEEKDAY, FILTER and SEQUENCE from this
By employing the SEQUENCE function in Excel, learn the simplest method to generate every nth day from a given date
Learn the quickest way to generate all the dates of a month using simple Excel formulas through this post.
This post shows how to use the SEQUENCE, and DATE functions in Excel to generate all the dates for an
This post guides you through the use of the SEQUENCE, WEEKDAY, and SUM functions to count the number of weekdays
Using the powerful DATE, EOMONTH and SEQUENCE functions in Excel, learn the simplest way to calculate the ending date of
By the use of DATE, and SEQUENCE functions learn the simplest way to calculate the starting date of any month