How to Use the TODAY Function in Excel

This guide explains how to use TODAY Function in Excel, including its syntax, required arguments, practical examples, and common errors.

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:

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

- Press Enter -> current date value is:

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

- Press Enter -> the corresponding return value is:

- Similarly copying the formula for the remaining values results:

- 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.

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

Good luck!