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 takes no parameters but requires empty parentheses.

Example of TODAY Function in Excel:


today function in excel 1


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


today function in excel 3


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

DataScience Made Simple