Which function would you use to insert the current date that can be used as a static date in a worksheet cell?

Which function would you use to insert the current date that can be used as a static date in a worksheet cell?

• A. DATE
• B. NOW
• C. TODAY
• D. TEXT

Answer: (C)

The function to use is TODAY. It returns the current date (without a time component) in a worksheet cell. Because TODAY is a formula, the value would normally update each day unless you freeze it. To make it static, copy the cell and use Paste Special > Values (or paste as values) to convert the result to a fixed date. NOW would include the current time, which isn’t a pure date. DATE requires explicit year, month, and day inputs, not the present date. TEXT would give you a text string, not a date value you can use in date calculations.

The function to use is TODAY. It returns the current date (without a time component) in a worksheet cell. Because TODAY is a formula, the value would normally update each day unless you freeze it. To make it static, copy the cell and use Paste Special > Values (or paste as values) to convert the result to a fixed date. NOW would include the current time, which isn’t a pure date. DATE requires explicit year, month, and day inputs, not the present date. TEXT would give you a text string, not a date value you can use in date calculations.