How to use excel today function

How to use excel today function: First open an Excel file; then select a cell; then enter the syntax format of today function as "=today()"; finally click Enter to get the current date.

Demonstration environment in the article: Windows 7 system, Microsoft Office Excel 2013 version, Dell G3 computer.

Recommended: "Excel Tutorial"

Today function returns the serial number of the current date. Serial numbers are date-time codes that Excel uses for date and time calculations. If the cell format was "General" before entering this function, Excel will change the cell format to "Date". To display serial numbers, you must change the cell format to "General" or "Number."

Usage:

1. The format of today function is =today(); TODAY function syntax has no parameters, as shown below, it directly returns the current date.

2. Example: =MONTH(TODAY()); Returns the current month of the year (1 - 12). For example, if the current month is November, this formula returns 11.

3. Example: =TODAY() 3; Returns the current date plus 3 days. For example, if the current date is 2016-11-23, this formula returns 2016-11-26.

The above is the detailed content of How to use excel today function. For more information, please follow other related articles on the PHP Chinese website!