It returns the serial number of the current date.
The syntax of the function is the following:
TODAY()
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here are two examples of how to use the TODAY function:
Insert your birthday date in the cell A1. Insert a function in the cell A2 that always displays the current date. Insert a function in the cell A3 that displays the number of the days you have lived. Format the cell A3 in Number category with a thousand separator and without decimals.
Enter a function in the cell A1 to display the current date.