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.
Excel Dates and Time
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.
Add time using Excel’s TIME() function
How to use Excel’s TIME function to add time to time, with a worked example to create a series of appointments.
Insert current DATE and TIME in Excel
How to display today’s date and time in Microsoft Excel
Insert current DATE in Excel
How to display today’s date in Microsoft Excel