Question

Suppose today is December 14, 2014. Which of the following functions will NOT return 12/14/2014 as a date?

Review Later
=DATE(2014,12,14)
=TODAY()
12/14/2014
=12/14/2014

Answer 1

Answer:

December is not return

Answer 2

Answer: The answer is based on Excel based programming

Today(): Excel's Date and Time functions have a feature called the TODAY Function. The date, as well as the time, will be calculated in the format 12/14/2014. Whenever a user makes a modification to a worksheet or opens a new worksheet, it is continually updated. The current date is what you will obtain when you run this function.

Explanation:

• To input the date, first write the date (such as February 2), and then go to the Home tab,
• click the Number Format option, and choose either Short Date or Long Date from the menu that appears.
• To enter the time, first input the time, and then go to the Home tab, click the Number Format option, and choose Time from the list.

Syntax of function is : Today()

#SPJ2