Excel FunctionsLesson 115Free preview
TODAY
This lesson is part of Excel · All levels
Summary
TODAY is an Excel date function that returns the date today in the form of a serial value. This function is volatile so the result is updated every time the worksheet is recalculated. TODAY has no arguments and is often used for counting backwards or ageing data.
Key points
- TODAY() without argument and always returning the date today
- Volatile, changing as the worksheet is recalculated
- Save the date as a serial number, then format it as a date
- Now returns the date at once, today only the date
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.