Skip to main content

How to Use the TODAY Function in Excel for Mac

Joshua earned an MBA from USF and he writes mostly about software and technology.

Using the TODAY function in Excel

Using the TODAY function in Excel

The Purpose of the TODAY Function

The TODAY function gives an Excel user the ability to have the current date appear on a work sheet.

The TODAY Function Syntax

The TODAY function needs to be inputted into a cell like a formula to work properly. To manually add this function the following steps need to be taken:

  1. A cell needs clicked type "=TODAY()"
  2. After the formula is created the formula can be entered.

Below in bold is the syntax of the TODAY function.

=TODAY()

The today function does not have any arguments.

Formula Example

As you can see in the example below, the TODAY function prints out the date. The cell can then be formatted with any date format to meet the needs of the user.

TODAY function

TODAY function

Practical Application

One example application where the TODAY function can be useful outside of just showing the current date is by using a list box that gives the choice of a range of dates from which to select.

For instance, suppose you need to select either yesterday's date or today's date, or tomorrow's date. Each date would be inputted into cells as shown in the illustration below with the function. When past dates or future dates need to be shown you must simply subtract or add respectfully.

Scroll to Continue

The list box is created with the following steps:

Choose a cell→Data Tab →Data Validation→List→Select range

List Box with Date Range

List Box with Date Range

Inserting the TODAY Function

The TODAY function can be inserted into a cell by selecting a cell followed by clicking the formula tab. Next, click on the date and time functions button and choose the TODAY function from the list.

Select the Function

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

Since there are no arguments to enter into the function, finish inserting the function by clicking the done button.

Formula builder

Formula builder

References

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

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

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.

© 2022 Joshua Crowder

Related Articles