How to Use the TODAY Function in Excel - TurboFuture - Technology
Updated date:

How to Use the TODAY Function in Excel

Joshua has work experience in manufacturing, distribution, and aerospace. He received his BBA in accounting from Kent State University.

The TODAY Function

The TODAY function is a useful function that can be used in tandem with other functions to determine past and future dates as well as determine the current date in its simplest form.

The TODAY function is a useful function that can be used in tandem with other functions to determine past and future dates as well as determine the current date in its simplest form.

The Purpose of the TODAY Function

The TODAY function is used to return the current date as long as the cell it is used in is formatted as a date. This function is very useful when you have other formulas that depend on the current date to make accurate calculations. Such a calculation may involve using today's date to figure out the remaining days until something is due. It could involve something a little more complex in an Excel workbook like when to trigger a macro process.

Nevertheless, the TODAY function is a very useful function and worth learning the various applications that are supported by this function.

The Today Function Syntax

The TODAY function needs to be inputted like a formula to work properly. To enter it, start by clicking into a cell and typing "=TODAY()" into the cell. After the closed parenthesis click enter. Unlike many other functions this one requires no arguments. The formula simply returns the current date as long as the cell that it is in has date formatting assigned to it.

Inserting the Today Function

The TODAY function can be inserted into a spreadsheet with the use of an insert tool. I don’t recommend using this method due to the simplicity of the syntax. The insert option could be used in the event that one forgets how to use the function syntax. The insert tool will basically just write the function for you.

To use this method a cell must first be selected. Next, the formulas tab is selected and the "Date & Time" button on the Excel ribbon needs to be selected. Choose the TODAY function from the drop down list.

how-to-use-the-today-function-in-excel

After the message box appears telling you that the function requires no arguments, click OK and the current date should appear. If not, then select the cell and go back to the home tab. In the numbers section, you should be able to change the formatting to date.

When this box appears after inserting a function it is merely to make sure you understand that the function does not require any data.

When this box appears after inserting a function it is merely to make sure you understand that the function does not require any data.

TODAY Function Examples

The following examples are just a few ways that the today function can be used in a worksheet.

=TODAY()

  • Displays that current date. For this example and the following examples, the format of the date will be determined by the format that is set for the cell that this function is used in.

=TODAY()-7

  • Displays the the date that was one week in the past. You can also go any number of days into the past as you wish.

=TODAY()+7

  • Displays the date that will come one week into the future. You can also go any number of days into the future as you wish.

= YEAR(TODAY())-1963

  • Displays the amount of years past by subtracting a certain year from today's date. For this example, it would be more practical to use a cell reference for the year if this example were used in an spreadsheet application.

=DAY(TODAY())

  • Determines the day in a number format of the current month. So, if it was July 5th, this formula would display the number 5 in a cell.

Practical Application Example

For an example, lets take a look at a situation where one may use the TODAY function on a day to day basis. Take into consideration the table in the illustration below. The information is part of a spreadsheet that is dedicated to tracking laboratory specimens related to plastics laboratory testing.

how-to-use-the-today-function-in-excel

Spreadsheet Column Descriptions

The table below show descriptions of the columns of the spreadsheet example. Three dates are tracked for which two will be used to find out to determine a binomial answer that results from an if statement and how many days have passed till a certain date.

ColumnDescription

Date Received

Date the raw plastic material arrived.

Test Needed by

Date that test specimen were molded and when the curing process starts.

Date Molded

Date that the test plaques were molded.

2 Day Cure?

Formula to determine.

Days Till Due Date

Formula to determine.

 

 

To determine if a two day cure has occurred, the today function uses the current date and subtracts the mold date. This type of calculation will give the difference of the two date resulting in the number of days that have passed.

Since the if formula is looking for a number greater than 2, a "Yes" appears in the cell. Otherwise, a "No" would appear until following days trigger the TODAY function to result in a difference greater than two.

how-to-use-the-today-function-in-excel

The calculation that determines that days till the due date is straight forward. The cell reference C4 represents the due which is subtracted by the todays date. The result will be the amount of day left until the due date occurs.

how-to-use-the-today-function-in-excel

References

Microsoft. (n.d.). TODAY function. Retrieved January 5, 2020, from https://support.office.com/en-us/article/today-function-5eb3078d-a82c-4736-8930-2f51a028fdd9.

Related Articles

How to Use the COUNT Function in Excel

How to Use the AVERAGE Function in Excel

How to Use the ABS Function in Excel

How to Remove Errors in Excel With the IFERROR Function

How to Use the VLOOKUP Function in Excel

Converting Measurement Units: Using the CONVERT Function

To learn more about using functions in Excel I recommend the following book. I have been using the Excel Bible for years to improve my understanding of all aspects of this Microsoft product.

The Excel 2019 Bible

This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.

© 2020 Joshua Crowder