Excel TODAY Function
Summary
The Excel TODAY function returns the current date, updated continuously when a worksheet is changed or opened. The TODAY function takes no arguments. You can format the value returned by TODAY using any standard date format. If you need current date and time, use the NOW function.
Purpose
Get the current date
Return value
Valid Excel date
Syntax
=TODAY ()
Arguments
Version
Usage notes
The TODAY function takes no arguments, and returns the current date, updated whenever a worksheet is changed or opened. You can also use F9 to force the worksheet to recalculate and update the value.
- If you need a static date that won't change, you can enter the current date using the keyboard shortcut Ctrl + ;
- If you need current date and time, use the NOW function.
Examples
Formatting results
The result of TODAY is a serial number representing a valid Excel date. You can format the value returned by TODAY using any standard date format, or use the TEXT function to build a text message that includes the current date.
TODAY formula examples
Note: the "current date" (i.e. today) for this example is May 31, 2016
With nested IF statements, the flow is from outer IF statements to inner IF statements, and the challenge is always to construct the flow so that...
The AND function takes multiple arguments and returns TRUE only when all arguments return TRUE. The TODAY function returns the current date. Dates in Excel are simply large serial numbers, so you can create a new...
Note: This example assumes the start date will be provided as the first of the month. See below for a formula that will dynamically return the first day of the current month.
With the layout of grid as shown, the main...
In this example, we want to apply three different colors, depending on how much the original date varies from the current date:
Green if the variance is less than 3 days
Yellow if the variance is between 3 and 10...
In the image shown, the current date is August 23, 2019.
Excel dates are serial numbers, so you can manipulate them with simple math operations. The TODAY function returns the current date on an on-going basis. Inside...
NETWORKDAYS is a built in function accepts a start date, end date, and (optionally) a range that contains holiday dates.
In this case, the start date is Jan 10, 2018, provided as cell B5. The end date is calculated...
The TEXT function can apply number formatting to numbers just like Excel's built-in cell formats for dates, currency, fractions, and so on. However, unlike Excel's cell formatting, the TEXT function works inside a...
Data validation rules are triggered when a user adds or changes a cell value.
This custom validation formula uses the WEEKDAY function to get a numeric value, 1-7, corresponding to to a week beginning Monday (1) and...
In the image shown, the current date is August 24, 2019.
Excel dates are serial numbers, so they can be manipulated with simple math operations. The TODAY function always returns the current date.
Inside the AND...
The SUMIFS function can handle multiple criteria when calculating a sum. In this case, SUMIFS is configured with a sum range for all amounts:
=SUMIFS($D$5:$D$104
The first criteria specifies a criteria range that...
Dates in Excel are serial numbers that start on 1/1/1900.
In the example, the formula in cell D6 simply subtracts the numeric value of 1/1/1999 (36161) from the numeric value of 1/1/2000 (36526) to get a result of 365...
Data validation rules are triggered when a user adds or changes a cell value.
This custom validation formula simply checks the year of any date against a hard-coded year value using the YEAR function.
When a user...
In the image shown, the current date is August 19, 2019.
Excel dates are serial numbers, so you can manipulate them with simple math operations. The TODAY function always returns the current date. Inside the AND...
In Excel, dates are simply serial numbers. In the standard date system for windows, based on the year 1900, where January 1, 1900 is the number 1. Dates are valid through 9999, which is serial number 2,958,465. This...
NETWORKDAYS is a built-in function accepts a start date, an end date, and (optionally) a range that contains holiday dates. In the example shown, we generate the start and end date using the DATE function like this:...
Related videos
In this video, we look at how to use a feature called Evaluate Formula to solve complex formulas one step at a time.
In this video we look at several options to enter a current date and time in a worksheet.
Most Excel functions require arguments. In this video, we explain how function arguments work and how to use them.
In this brief video, we look at how to debug a formula using the F9 key. If you work with formulas a lot, this is one of the most useful skills you can learn.
In this lesson we look at how to generate an expiration date in the future, how to calculate "days remaining," and how to highlight dates that are "expired" or "expiring soon" with conditional formatting.
Related functions
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.
