Question

In cell J1, enter a formula using the NOW function to display today's date. Apply the short date number format to display only the date in the cell.

A) =TODAY()
B) =NOW()
C) =NOW() + 1
D) =TODAY() + 1

Answer 1

To display today's date in cell J1 with a formula, use the =NOW() function and apply the short date number format to show only the date. The correct answer to the question is option B) =NOW().

Step-by-step explanation:

To display today's date in cell J1 using a formula, you should use the =NOW() function. Although both =TODAY() and =NOW() can be used to get the current date, the =NOW() function also includes the current time. Since you want to display only the date, after entering the formula, you should apply the short date number format to the cell to exclude the time. Therefore, the correct answer is B) =NOW(). To apply the short date format, you can go to the format cells option and select 'Short Date' from the number tab.