What is the difference between TODAY() and NOW() Function?
Answer & explanation
Correct answer: option 4
The correct answer is Option (4) → TODAY() returns today's date while NOW() returns current date and time
Both are date functions of a spreadsheet and both need nothing inside the brackets. TODAY() gives only the current date. NOW() gives the current date together with the current time, so its value keeps changing during the day.
Why the other options are incorrect
Option (1) TODAY() returns current Time while NOW() returns current day — Incorrect. This has the two functions the wrong way round; TODAY() never shows the time.
Option (2) TODAY() returns today's day while NOW() returns current time only — Incorrect. NOW() returns the date as well as the time, not the time alone.
Option (3) TODAY() returns current month while NOW() returns current date — Incorrect. TODAY() returns the full date, not just the month, and NOW() adds the time to the date.
NCERT (2026-27 edition):
|
