Convert Start & End Dates into Monthly Periods in Power Query

Learn how to use Power Query in Excel to convert Start and End date columns into clear month-year periods like Jan-2025 and Feb-2025. This step-by-step guide helps you prepare your data for monthly reports, dashboards, and analysis with ease.

Apple Silicon processors now support Power Query Excel for Mac

For a long time, Excel has been an Apple Silicon native (along with the rest of Office, except OneDrive). However, Power Query was the only tool that required Rosetta to run on Apple Silicon Macs. But now with the latest update, it has been enhanced to be Apple Silicon (M1, M1 Pro, M1 Max) native, Excel Power Query no longer requires Rosetta.