Exceljet

Quick, clean, and to the point

Excel TODAY Function

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 
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.

Examples

=TODAY() // current date
=TODAY()-7 // one week ago
=TODAY()+7 // one week later

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.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables