What is the difference between TODAY() and NOW() Function?

TODAY() returns today's date while NOW() returns current date and time

The correct answer is option 4- TODAY() returns today's date while NOW() returns current date and time.

Date and Time Function

1. TODAY () is the function for today’s date in the blank worksheet. TODAY – Returns the serial number of the current date. The serial number is the date-time code used by Excel for date and time calculations. Times are represented as fractions of a day. By default January 1, 1900 is serial number 1. Thus, January 1, 2009 is serial number 39814 (because it is 39814 days after January 1, 1900).

2. NOW () is similar function but it includes the current time also.

3. DAY(serial_number) function returns the day of a date as an integer ranging from1 to 31. For example, if A5 = 16-Apr-2009 then = DAY (A2) will be 16. Similarly, two other functions MONTH (serial_number) returns month of a date as an integer ranging from 1 (January) to 12 (December) and YEAR (serial_number) returns the year corresponding to a date as an integer ranging from 1900 – 9999.

4. DATEVALUE (date_text) converts a date in the form of text to a serial number e.g. = DATEVALUE (“16-04-2009”) will return a value 39919.