Power Query extract year and month from date
How to get year and month from date in Excel Power Query, including how to create the steps in Advanced Editor.
Date
Day of the week from date in Excel
How to get the weekday number and day of the week from a date in Excel. Examples with syntax including how to use the WEEKDAY() and TEXT() functions and errors to watch out for.