Excel - TODAY Function, Return Current Date, Illustrative Examples

Buzz

Content

TODAY Function in Excel

How to use the TODAY function in Excel - Illustrative Examples

In Excel, the TODAY function helps you accurately retrieve the current date and time. If you forget how to use the TODAY function, refer to the following article by Mytour.

TODAY Function in Excel

How to use the TODAY function in Excel - Illustrative Examples

Syntax:=TODAY()

Function: Returns the current date, it does not contain any parameters and the time is implicitly understood to be 0 hours.

Example

Example 1: To get today's date, you press =TODAY() and the result will be as shown below.

= TODAY()=6/16/2014

Example 2: Using in combination with other functions. You have a spreadsheet as shown below

You want to calculate the age of the people in your table, you do as follows:

In cell H9 you type: =YEAR(TODAY())-F9 and then press Enter. You will get the result as shown below:

Click and hold the mouse to drag the result for the remaining cells:

Example 3: Returns the current date plus 10

=TODAY() +10=18/6/2014

You can combine the TODAY function in Excel with many other functions to serve your calculation work. Also, if you want to get both the current date and time, you can use the NOW function in Excel.

Frequently Asked Questions

What is the correct syntax for using the TODAY function in Excel?

The correct syntax for the TODAY function in Excel is simply =TODAY(). This function does not require any parameters and returns the current date, implicitly understanding the time as 0 hours.

How can I use the TODAY function to calculate age in Excel?

To calculate age using the TODAY function in Excel, enter the formula =YEAR(TODAY()) - F9 in the desired cell, where F9 contains the birth date. This calculates the current year minus the birth year, providing the age.

Can the TODAY function be combined with other functions in Excel?

Yes, the TODAY function can be combined with various other functions in Excel. For example, you can add days to the current date using =TODAY() + 10 to get a date 10 days from today.

Is it possible to retrieve both date and time using Excel functions?

Yes, to retrieve both the current date and time in Excel, you should use the NOW function instead of the TODAY function. The NOW function returns the current date and time with hours and minutes.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]