Which function finds current date?

The correct function to find the current date in Excel is TODAY(). This function returns only the current date, without any time component, and updates automatically whenever the worksheet is recalculated or opened. It's ideal for displaying just the date.

• NOW() is a common distractor because it returns both the current date and the current time, which is different from just the date.
• DATE is a function used to construct a date from separate year, month, and day values (e.g., DATE(2023, 10, 26)), not to retrieve the current system date.
• TIME is used to create a time value or extract time components, similar to how DATE works for dates, and does not find the current date.