Change the date system, format, or two-digit year interpretation
You can view a date as a serial value and a time as a decimal fraction by changing the format of the cell that contains the date or time to General format.
Video: Conditionally format dates - Microsoft Support
Take conditional formatting to the next level. Training: Say you want to see, at a glance, what tasks in a list are late. In other words, those tasks with due date dates before today. Or which tasks aren’t due for a week or more. Watch this video to learn how.
Add a custom column (Power Query) - Microsoft Support
Date.DayOfWeekName([DOB]) Creates a new column that displays a weekday name, such as Monday, derived from a DOB Date/Time column data type. DateTime.Time([DOB])
Video: Conditionally format dates - Microsoft Support
Add, change, find, or clear conditional formats. Take conditional formatting to the next level. Training: Say you want to see, at a glance, what tasks in a list are late. In other words, those tasks with due date dates before today. Or which tasks aren’t …
Video: Use formulas to apply conditional formatting - Microsoft …
Use conditional formatting. Manage conditional formatting rule precedence. In this example, I am going to format the cells in the Product column if the corresponding cell in the In stock column is greater than 300. When you select a range of cells, the first cell you select is the active cell.
Filter data (Power Query) - Microsoft Support
You can filter by date/time value using the Date/Time Filters submenu. To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, load, or edit a query in Excel.
Enter and format data - Microsoft Support
Enter and format data. Enter & find Format Layout Validation Customize. Enter data manually in worksheet cells. Fill data automatically in worksheet cells. Turn Flash Fill on in Excel 2016. Move or copy worksheets or worksheet data. Create a list of sequential dates. Create a custom list.
Enter data in multiple worksheets at the same time
In Excel, you can enter the same data into several worksheets without retyping or copying and pasting the text into each one. For example, you want to put the same title text into all worksheets in your workbook.
Video: Use slicers, timelines, and PivotCharts to analyze your ...
In the upper-right of the timeline, click the drop-down arrow, and choose a timeframe, such as Days. Use the slider to move along the timeline. Select the day, click an end of the selector, and drag it to cover the time period you want. And the PivotTable now displays the sales for …
Change the date system, format, or two-digit year interpretation
You can view a date as a serial value and a time as a decimal fraction by changing the format of the cell that contains the date or time to General format.
Sort by dates - Microsoft Support
When dates in a worksheet aren't in the order you want, you can sort them. For example, you can sort them from oldest on top to newest on top. Here's how to sort unsorted dates: Drag down the column to select the dates you want to sort. Click Home tab > arrow under Sort & Filter, and then click Sort Oldest to Newest, or Sort Newest to Oldest.