78K views · 410 reactions | 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 | Facebook

1.4M views · 8.9K reactions | Day Name Extractor: Retrieve Day Name from Date with Excel Functions! Learn how to extract the day name from a date using Excel functions. Elevate your spreadsheet skills and dive into this tutorial to efficiently retrieve the day name for your date data. Watch, learn, and streamline your date analysis with this simple yet powerful technique!  #ExcelTips #DayNameExtractor #SpreadsheetSkills #DateAnalysis #ExcelMagic | Excel Formulas Unleashed | Facebook