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:
Result:
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:
Result
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