TODAY

Formulas / TODAY
The TODAY function returns the current date based on the computer's system date, automatically updating to reflect the current date whenever the worksheet is recalculated.
=TODAY()
The TODAY function does not have any arguments. It simply returns the current date based on the computer's system date. The syntax for the TODAY function is: TODAY()

Examples

  • =TODAY()

    This formula returns the current date based on the computer's system date. The value is automatically updated whenever the worksheet is recalculated to always reflect the current date.

  • =TODAY()+7

    This formula returns a date that is 7 days in the future from the current date. It calculates this by adding 7 to the current date returned by the TODAY function.


Summary

The TODAY function returns the current date based on the computer's system date, with no need for arguments or input parameters.

  • The TODAY function is a date and time function that returns the current date based on the computer's system date, with no need for arguments or input parameters.
  • The value returned by the TODAY function automatically updates to reflect the current date whenever the worksheet is recalculated, ensuring that it always represents the current date.
  • The TODAY function can be used in calculations to determine future or past dates by adding or subtracting a specific number of days to or from the current date.

Frequently Asked Questions

What does the TODAY function do?
The TODAY function returns the current date based on the computer's system date. It does not require any arguments and automatically updates to reflect the current date whenever the worksheet is recalculated.
Can the TODAY function be used to calculate future or past dates?
Yes, the TODAY function can be used in calculations to determine future or past dates. By adding or subtracting a specific number of days to or from the TODAY function, you can calculate dates in the future or the past.
Does the TODAY function require any arguments?
No, the TODAY function does not require any arguments. It simply returns the current date based on the computer's system date when entered as TODAY().
How often does the value returned by the TODAY function update?
The value returned by the TODAY function updates automatically whenever the worksheet is recalculated. This ensures that the value always reflects the current date based on the computer's system date.
Can the TODAY function be used to calculate the number of days between two dates?
Yes, the TODAY function can be used to calculate the number of days between two dates. By subtracting a specific date from the TODAY function, you can calculate the number of days between that date and the current date.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV