Beginner
Date & Time
TODAY
Returns the current date, and updates automatically every day the file is opened.
Compatibility: All Excel versions
Syntax
=TODAY()
Example
=TODAY()
When to Use It
Use TODAY to timestamp a sheet, or combine it with other formulas to calculate someone's age or how many days are left until a deadline.