Learn How to Use MS Excel TODAY Function

Microsoft Excel TODAY Function

The prime purpose of the TODAY function is to get the current date. So, the MS Excel TODAY function returns the current date, which is updated continuously when the worksheet is changed or open. You can't add any arguments with the TODAY function, but you can format the value returned by TODAY as per any standard date format. You can also use the NOW function to get the current date and time.

TODAY Function Return Value

The return value will be the valid Excel date.

TODAY Function Syntax

= TODAY()

How to Use Microsoft Excel TODAY Function?

As you must have understood till now, that it is very easy the TODAY function. Besides that, you won't be able to add any arguments with the TODAY function and return the current date using it, which is updated when the worksheet is changed or updated. You can also use F9 to force Excel to recalculate and update the value. Below are some of the examples of TODAY function:

• = TODAY( ) - This will return the current date.
• = TODAY( ) -7 - This will return the date one week ago.
• = TODAY( ) +7 - This will return the date one week ahead.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel