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
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:
- A cell needs clicked type "=TODAY()"
- 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
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.
The list box is created with the following steps:
Choose a cell→Data Tab →Data Validation→List→Select 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
Since there are no arguments to enter into the function, finish inserting the function by clicking the done button.
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
- How to Use the AVEDEV Function in Excel for Mac
This tutorial shows how to use the AVEDEV function in Excel. - How to Use the CHAR Function in Excel for Mac
This tutorial shows how to use the CHAR function in Excel. - How to Use the VALUETOTEXT Function in Excel for Mac
This tutorial shows how to use the VALUETOTEXT function in Excel. - How to Use the BAHTTEXT Function in Excel for Mac
This tutorial shows how to use the BAHTTEXT function in Excel. - How to Use the FISHER Function in Excel for Mac
This tutorial shows how to use the FISHER function in Excel. Examples are shown with a Mac but relevant to PC users.
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
