Joshua is a graduate student at the USF. He has interests in business technology, analytics, finance, and lean six sigma.
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 very useful, and it's worth learning the various applications that are supported by this function.
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 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.
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.
TODAY Function Examples
The following examples are just a few ways that the today function can be used in a worksheet.
- 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.
- Displays the date that was one week in the past. You can also go any number of days into the past as you wish.
- 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.
- Displays the number 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 a spreadsheet application.
- 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.
TODAY Function Practical Application Example
For example, let's 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.
Spreadsheet Column Descriptions
The table below shows 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.
Date the raw plastic material arrived.
Test Needed by
Date that test specimen were molded and when the curing process starts.
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 between the two dates resulting in the number of days that have passed.
Since if the formula is looking for a number greater than 2, a "Yes" appears in the cell. Otherwise, a "No" would appear until the following days trigger the TODAY function to result in a difference greater than two.
The calculation that determines the days till the due date is straightforward. The cell reference C4 represents the due which is subtracted by today's date. The result will be the amount of days left until the due date occurs.
Microsoft. (n.d.). TODAY function. Retrieved January 5, 2020, from https://support.office.com/en-us/article/today-function-5eb3078d-a82c-4736-8930-2f51a028fdd9.
- How to Use the TREND Function in Excel
Covers how to use the TREND function in Microsoft Excel with the correct syntax and an example.
- How to Use the PERCENTILE Function in Excel
Here I cover in detail how to use the PERCENTILE function in Excel with the correct syntax.
- Converting Measurement Units: Using the Convert Function in Microsoft Excel
Describes how to use the CONVERT function within Microsoft Excel to convert various types of measurement units to other types of units. Types of conversions include: weight and mass, distance, time, pressure, force, energy , power, magnetism, tempera
- How to Use the VLOOKUP Function in Excel
Covers how to use the VLOOKUP function in Microsoft Excel with examples on the correct syntax to use.
- How to Remove Errors in Excel With the IFERROR Function
Shows a Microsoft Excel user how to apply the IFERROR Function to remove errors in cells.
- How to Use the ABS Function in Excel
Covers how to use the ABS function in Microsoft Excel with examples on the correct syntax to use.
- How to Use the AVERAGE Function in Excel
Shows how to use the AVERAGE function in Excel with application examples.
- How to Use the COUNT Function in Excel
Shows a Microsoft Excel user how to use the count function in a spreadsheet.
Learning More About Excel Functions
To learn more about using functions in Excel I recommend purchasing Excel Formulas & Functions For Dummies.
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