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?
- A.
TODAY( )
- B.
NOW( )
- C.
Both (A) and (B)
- D.
None of the above
Attempted by 166 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.