Question

Which function displays only the current date in MS-Excel?

• A. date()
• B. now()
• C. today()
• D. all of these

Answer 1

Answer:

C. today()

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.