TODAY function

Category: Date and time
Introduced: Excel 2003

Summary

Returns the serial number of today's date

Syntax

TODAY() The TODAY function syntax has no arguments.
Note: Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900.

Example

=TODAY()
=TODAY()+5
=DATEVALUE("1/1/2030")-TODAY()
=DAY(TODAY())
=MONTH(TODAY())

Microsoft Support Page

https://support.microsoft.com/en-us/office/today-function-5eb3078d-a82c-4736-8930-2f51a028fdd9

Back to Functions