Question

Which function inserts the current date in an Excel cell?

• A. =NOW()
• B. =TODAY()
• C. =DATE()
• D. =CURRENTDATE()

Answer 1

Answer:

B. =TODAY()

The `TODAY()` Function

• The `TODAY()` function in Microsoft Excel is a built-in function used to insert the current date into a cell.

• It is a volatile function, meaning it recalculates and updates its value every time the worksheet is opened or changed.

• The syntax is simple: `=TODAY()`. It does not require any arguments.

• When you enter `=TODAY()` into a cell and press Enter, Excel displays the date of the day the calculation was performed.