Which command inserts today's date into cell A1 without the time?

Which command inserts today's date into cell A1 without the time?

• A. NOW function
• B. TODAY function via Formulas -> Date & Time
• C. TODAY function directly in the cell
• D. INSERT Date

Answer: (B)

Date functions for dates only. TODAY returns the current date as a date value and does not include any time portion. That makes it perfect for a cell that should show today’s date every day, without displaying a time. The value updates automatically as the day changes, since it’s dynamically calculated. Using the command path Formulas -> Date & Time to insert TODAY places a formula like =TODAY() into the selected cell, ensuring you get that date-without-time behavior. This is the intended method here because it explicitly adds the date function through the UI, aligning with the goal of inserting today’s date without a time part. If you type =TODAY() directly into the cell, you’d get the same result, but the question highlights using the menu path. In contrast, NOW would bring date and time, which is not what you want if you’re aiming for a date only.

Date functions for dates only. TODAY returns the current date as a date value and does not include any time portion. That makes it perfect for a cell that should show today’s date every day, without displaying a time. The value updates automatically as the day changes, since it’s dynamically calculated.

Using the command path Formulas -> Date & Time to insert TODAY places a formula like =TODAY() into the selected cell, ensuring you get that date-without-time behavior. This is the intended method here because it explicitly adds the date function through the UI, aligning with the goal of inserting today’s date without a time part. If you type =TODAY() directly into the cell, you’d get the same result, but the question highlights using the menu path. In contrast, NOW would bring date and time, which is not what you want if you’re aiming for a date only.