Question

Which of the following functions is used to display only current system date in Ms Excel 2010?
1. Date() 
2. Today()
3. Time()
4. Now() 

Answer 1

Correct Answer - Option 2 : Today()

The correct answer is Today().

• The TODAY() function takes no arguments and returns the current date, updated whenever a worksheet is changed or opened.
• You can also use F9 to force the worksheet to recalculate and update the value.
• If you need the current date and time, use the NOW() function. 

• The DATE() Function in Excel is categorized under Excel Date/Time Functions.
• It is the main function used to calculate dates in Excel.
• TIME() function is a built-in function that allows you to create a time with individual hour, minute, and second components.