Site icon Best Excel Tutorial

How to Use TODAY Function in Excel

In this Excel tutorial, you will learn how to use the TODAY function. This function is really easy and is more powerful than you thought.

The TODAY function, which returns the current system date, finds extensive use across multiple applications, including logistics. For instance, it can be pivotal in calculating the remaining days until a delivery or transportation date.

What is the TODAY function in Excel?

TODAY stands for “Today’s Date”. It is a function that takes no arguments and returns the current date in the form of a serial number. The serial number for today’s date is always increasing, so you can use the TODAY function to track the passage of time.

The TODAY function works by retrieving the current date from the computer’s operating system. The date is then converted into a serial number and returned by the function.

Today function syntax

Syntax is just =TODAY()

Excel will display the current date, e.g., 2013-07-30

As you see above, the TODAY function has no arguments. Its correct result depends on correctly setting the date (and time) in Windows.

How do I calculate how many years have passed?

The answer is 27 years. Yes, I am 27 years old.

How do I calculate the time difference using the TODAY function?

Today function examples

Note that the TODAY function is a volatile function, which means it will recalculate every time the worksheet is opened or recalculated, even if there are no changes to the worksheet.

Exit mobile version