Create Dimension Calendar Table in #Excel 365 - ONE FORMULA! =LET( StartDate, DATE(2025,1,1), EndDate, DATE(2025,12,31), Dates, SEQUENCE(EndDate-StartDate 1,,StartDate,1), HSTACK( Dates, TEXT(Dates,{"d","ddd","m","mmm","e"}), WEEKNUM(Dates,2), "Q"&ROUNDUP(MONTH(Dates)/3,0), "Q"&CHOOSE(MONTH(Dates),3,3,3,4,4,4,1,1,1,2,2,2,))) | Excel Basement

Check out some of my collection of Excel Quick Tips from my Reels! Keep on learning💻 ⌚ Timestamps⌚ 00:00 - Text to Dates 00:44 - Automatically Display the Days of the Week for Dates 01:32 - Add Current Date and Time 01:57 - Insert Date Using Calendar and Date Picker 03:10 - Automatically Color Cells Based on Due Dates 04:30 - Convert Days in Capital Letters 05:08 - Automatically Insert Weekdays Next to Dates 05:52 - Automate Dates Using Edate Function 06:50 - Automate Sequential Numbering with