DATEVALUE function - Microsoft Support
2008年1月1日 · This article describes the formula syntax and usage of the DATEVALUE function in Microsoft Excel. The DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date. For example, the formula =DATEVALUE ("1/1/2008") returns 39448, the serial number of the date 1/1/2008.
Convert dates stored as text to dates - Microsoft Support
To convert a text date in a cell to a serial number, use the DATEVALUE function. Then copy the formula, select the cells that contain the text dates, and use Paste Special to apply a date format to them. Click the cell that contains the text-formatted date that you want to convert.
DATE function - Microsoft Support
Use Excel's DATE function when you need to take three separate values and combine them to form a date. The DATE function returns the sequential serial number that represents a particular date. Year Required. The value of the argument can include one to four digits. Excel interprets the argument according to the date system your computer is using.
Create or delete a custom list for sorting and filling data
Use a custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom list. To understand custom lists, it is helpful to see how they work and how they are stored on a computer.
Format a date the way you want - Microsoft Support
2012年2月2日 · Press Control+1 or Command+1. In the Format Cells box, click the Number tab. In the Category list, click Date , and then choose a date format you want in Type .
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.
MONTH function - Microsoft Support
Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December). Syntax. MONTH(serial_number) The MONTH function syntax has the following arguments: Serial_number Required. The date of the month you are trying to find.
Add a trend or moving average line to a chart - Microsoft Support
Learn how to add a trendline in Excel, PowerPoint, and Outlook to display visual data trends. Format a trend or moving average line to a chart.
Format numbers as dates or times - Microsoft Support
2009年2月2日 · On the Home tab, in the Number group, click the Dialog Box Launcher next to Number. You can also press CTRL+1 to open the Format Cells dialog box. In the Category list, click Date or Time. In the Type list, click the date or time format that you want to use.
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.
Count numbers or dates based on a condition - Microsoft Support
To count numbers or dates that meet a single condition (such as equal to, greater than, less than, greater than or equal to, or less than or equal to), use the COUNTIF function. To count numbers or dates that fall within a range (such as greater than 9000 and at the same time less than 22500), you can use the COUNTIFS function.