How to enter year, month and day in excel

How to enter the year, month and day in excel?

Method 1:

Step 1: Quickly enter a regular date series:

If you need to enter a date series with a fixed interval number (this interval can be years, months, days) in the worksheet, use formulas to process it. Efficient.

Step 2: Enter the format of ****-*-* directly in the cell. For example: 2013-8-12. Just press Enter.

Step 3: You can also directly enter 2013/8/12 in the cell.

Method 2:

Step 1: Before entering the date, we must first understand how Excel stores date data. Dates are stored as numerical values ​​in Excel. When we enter the date 2014-08-28 in the cell and then clear the format of the cell, the cell will display the value 41879. As shown in the figure below

# Step 2: How is this value obtained? In fact, Excel stipulates that January 1, 1900 represents the value 1, January 2, 1900 represents the value 2, and so on. All dates represent the number of days from January 1, 1900.

As shown in the figure below

## Step 3: Based on the above understanding, we know that dates and numerical values ​​are actually interoperable, that is, dates are based on numerical values To store, numerical values ​​can actually be converted into dates. For example, if you enter 1 in a cell and then set the cell format to long date, it will be displayed as 1900-1-1. As shown in the figure below

# Step 4: After mastering the above knowledge, you also need to understand the date format that Excel can recognize.

Step 5: For example, entering 2014-1-1, 2014/1/1, January 1, 2014, etc. in cell A1 will be recognized by Excel as a standard date format. If you enter 2014.1.1, Excel will not recognize it and will treat it as text.

Step 6: If you want to display the date in the form of 2014.1.1, you can do this by setting the cell format to yyyy.mm.dd. As shown in the figure below

#For more Excel-related technical articles, please visit the

Excel Basic Tutorial column!

The above is the detailed content of How to enter year, month and day in excel. For more information, please follow other related articles on the PHP Chinese website!