Create Month-Year from Dates in Seconds! Excel Power Query (Mac/Windows) @ExcelExciting
Create Month-Year from Dates in Seconds! Excel Power Query (Mac/Windows)  @ExcelExciting
Uploaded April 2025 | Updated November 2026, 3 days ago
Learn how to quickly convert Start and End dates into month-year periods like Jan-2025, Feb-2025, and more using Power Query in Microsoft Excel.

Perfect for monthly reports, dashboards, and automating date transformations โ€” no coding needed!

๐Ÿ’ฌ Got questions? Drop them in the comments below!

๐Ÿ“Œ Time Stamp
00:00 Intro
00:35 Convert Into Excel Tables
00:55 Get Data From Blank Query
01:10 Excel.CurrentWorkbook to load in Mac
01:30 Bulding the solution
05:10 Load Data into Excel
05:30 Add more data
05:45 End

๐ŸŒ Download
Sample File : excelexciting.com/correct-duplicate-count-in-microsoft-excel-pivottable-cell-reference-method
--------------------------------------------------------------
๐Ÿ›’ Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk

๐Ÿ“ฃ Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family ๐Ÿ‘จโ€๐Ÿ‘ฉโ€๐Ÿ‘งโ€๐Ÿ‘ฆ so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
๐ŸŒŽ ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
๐Ÿ‘๐Ÿป Like Facebook Page :
facebook.com/ExcelExciting

๐Ÿ‘ฅJoin The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well


***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
Create Month-Year from Dates in Seconds! Excel Power Query (Mac/Windows)Move the Grand Total to the left or to the first column in Excel PivotTableCleaning Data in Excel: Functions Every Analyst Should Know with Hidaya MegateliUnlock The Power Of Data Tables In Microsoft Excel! ๐Ÿ“ŠWindows Trick# 11 - Change Mouse Pointer Color & Size In Windows 11 - #shorts  #mousepointer #tipsGet Instant Formula Results with the New Value Tooltip Feature (English)Hindi - StockHistory In Excel (mac & windows)Easily capture your work steps | Life Saver Free App very helpful during Covid-19Trick to Create A Data Entry Table In Power Query for ExcelLookup last matching value in the column (Excel - Mac & Windows)See the power of Power BI in 90 minutes: Marketing Dashboard with Power BI with Nurana NovruzovaGetting started with Office Scripts by Mark Proctor
Faraz Shaikh |

Create Month-Year from Dates in Seconds! Excel Power Query (Mac/Windows)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER