How to get year and month from date in Excel Power Query, including how to create the steps in Advanced Editor.
Excel Dates and Time
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.
How to use Excel’s TIME function to add time to time, with a worked example to create a series of appointments.
How to display today’s date and time in Microsoft Excel
How to display today’s date in Microsoft Excel