TODAY Function in Excel – Get Current Date or Todays Date

TODAY Function in Excel returns the current date i.e. Todays date. TODAY Function does not take any arguments.

Syntax for TODAY Function in Excel:

TODAY ()

TODAY takes no parameters but requires empty parentheses.

Example of TODAY Function in Excel:

Formula:

today function in excel 1

Result:

today function in excel 2

Application of Excel TODAY Function as a countdown:

The following example shows use of the TODAY function. Difference between date of meeting and TODAY is calculated and used as count down

Formula:

today function in excel 3

Result

today function in excel 4

 

Totally 3 days left for meeting.

NOTE: TODAY Function is updated continuously when a worksheet is changed or opened

If you want to get current date and time you can use NOW Function

previous-small TODAY Function in Excel                                                                                                                next_small TODAY Function in Excel