Question

Which function displays current date and time in MS Excel?

• A. Today()
• B. Time()
• C. Now()
• D. Date()

Answer 1

Answer:

C. Now()

NOW is an Excel DATE function that shows the current system date and time in an Excel worksheet. This function does not take any arguments and only gives the system date time on the system in which the function is being used. The method to use this function is NOW(). Displaying the current date: To display the current date in a cell, simply enter the formula =TODAY(). The cell will show the current date, and it will update automatically each time you open the workbook or recalculate the worksheet. The TIME Function is categorized under Excel DATE/TIME functions. TIME helps us to create a time with individual hour, minute, and second components. DATE(year, month, day) returns a serial number of a date based on the year, month and day values that you specify.