Introduction
In this article, we are going to learn two very important functions, Today and Now functions in Excel, which makes your task very easier.
We will see the syntax of the functions, their uses, return values, formats, and the function arguments in detail.
Moreover, to give you more clarity, we will also see a few examples of functions and their expected results.
Let’s get started.
TODAY Function
The TODAY function is useful for displaying the current date on the worksheet whenever you open it. Moreover, we can also use it for calculating intervals when you pass the TODAY() function as an argument to the YEAR function and compute the difference between two dates like YEAR(TODAY()) - 2001.
Return value
The TODAY function returns the serial number of the current date. Excel uses the date-time code as the serial number for calculating the date and time.
Syntax
The syntax is TODAY(), and the function takes no arguments.
Examples
In this section, we will see the different ways in which one can use the TODAY() function in Excel.
-
Formula: =TODAY()
It returns the current date, like 16/03/2022.
-
Formula: =DAY(TODAY())
It returns the current day number of the month and can range from 1 to 31.
-
Formula: =MONTH(TODAY())
It returns the month number of the current date. Like if the current month is April, it will return 4.
-
Formula: =DATEVALUE("1/1/2025")-TODAY()
It returns the number of days between the current date and the date “1/1/2025”.
-
Formula: =TODAY()+10
It returns the date after 10 days from the current date. So, if the current date is 16/03/2022, it will return 26/03/2022.
46+ registered 