WEEKDAY function - Microsoft Support
Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default.
Date and time functions (reference) - Microsoft Support
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
How to correct a #VALUE! error in the DATEVALUE function
2000年6月22日 · When Excel finds an incompatibility between the format in the date_text argument and the system’s Date and Time settings, you will see a #VALUE! error.
Free weekly calendar templates on Microsoft365.com
Download weekly calendars, planners, and scheduling templates for Excel.
Formulas and functions - Microsoft Support
Learn these top skills to create your own formulas and functions.
Add a custom column (Power Query) - Microsoft Support
Creates a new column that displays a weekday name, such as Monday, derived from a DOB Date/Time column data type. DateTime.Time([DOB]) Creates a new column that displays just the time derived from a DOB Date/Time column data type.
Excel calendar templates - Microsoft Support
Download pre-built Excel calendar templates. Stay organized with a variety of Excel calendar layouts and templates you can easily adapt to your needs.
Create a list of sequential dates - Microsoft Support
You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.
Show dates as days of the week - Microsoft Support
There are several ways to show dates as days of the week. Note: The screenshot in this article was taken in Excel 2016. If you have a different version your view might be slightly different, but unless otherwise noted, the functionality is the same. Select the cells that contain dates that you want to show as the days of the week.
Calculate the difference between two dates - Microsoft Support
Calculate the difference between two dates. Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios. For more information, please go to the known issues section of the DATEDIF function article.
Use AND and OR to test a combination of conditions
When you need to find data that meets more than one condition, such as units sold between April and January, or units sold by Nancy, you can use the AND and OR functions together. Here's …