Which formula would you enter in cell A1 to insert the current date without time?

Using the formula =TODAY() in cell A1 effectively inserts the current date without any time component. This formula automatically updates each day to reflect the current date whenever the worksheet recalculates. It is specifically designed to return the date in a format that excludes the time, solely providing the year, month, and day.

The other formulas present do not serve the same purpose: =NOW() returns the current date and time, which is not what is needed if you only want the date. =CURRENT() is not a valid Excel function, meaning it won’t provide any output. =DATE() requires specific arguments (year, month, and day) to generate a date, but does not inherently return the current date. Therefore, using =TODAY() is the most appropriate and straightforward approach to achieve the desired result of inserting just the current date.