In MS Excel, which of the following formulas will give the current system date?

2021

In MS Excel, which of the following formulas will give the current system date?

Answer: C. Both (A) and (B) — The TODAY( ) function in Excel returns the current system date without time. The NOW( ) function returns both date and time.

  1. A.

    TODAY( ) 

  2. B.

    NOW( )

  3. C.

    Both (A) and (B)

  4. D.

    None of the above

Attempted by 426 students.

Show answer & explanation

Correct answer: C

The TODAY( ) function in Excel returns the current system date without time. The NOW( ) function returns both date and time.

Explore the full course: Up Police Computer Operator

Loading lesson…