TODAY function - The function returns the current date value in the format in Excel

The following article introduces you to the TODAY function - one of the functions in the date and time group function is very popular in Excel.

TODAY function - The function returns the current date value in the format in Excel Picture 1

Description: The function returns the current date value in the format in Excel. The Today () function does not automatically update, but requires changes to the settings.

Syntax: TODAY ()

The Today function has no arguments.

Attention:

- Excel stores the date as a serial number to facilitate the calculation process.

- In case of adding (subtracting) an integer into the value of the TODAY () function -> that value is rounded when adding (subtracting)

For example:

Calculate the values ​​according to the table described below:

TODAY function - The function returns the current date value in the format in Excel Picture 2

- In the cell to calculate enter the formula: = TODAY ()

TODAY function - The function returns the current date value in the format in Excel Picture 3

- Press Enter -> current date value is:

TODAY function - The function returns the current date value in the format in Excel Picture 4

- In case you want to add or subtract, add value to the Today () function -> enter the formula: = TODAY () + 1.

TODAY function - The function returns the current date value in the format in Excel Picture 5

- Press Enter -> the corresponding return value is:

TODAY function - The function returns the current date value in the format in Excel Picture 6

- Similarly copying the formula for the remaining values ​​results:

TODAY function - The function returns the current date value in the format in Excel Picture 7

- In case of adding (subtracting) an integer number added to the date value -> that value is rounded. For example, here 0.5 is half a day but the function returns rounding to 1 day.

TODAY function - The function returns the current date value in the format in Excel Picture 8

Above are instructions and some specific examples when working with the TODAY () function in Excel.

Good luck!