Question

Which function will NOT return 12/14/2014 as a date?

A) =12/14/2014
B) =TODAY()
C) =DATE(2014,12,14)
D) 12/14/2014

Answer 1

Option B) =TODAY() will NOT return the date 12/14/2014 because this function always returns the current day's date, which changes daily.

Step-by-step explanation:

The question asks which function will NOT return the date 12/14/2014 in a spreadsheet or similar program. Let's evaluate the options:

• A) =12/14/2014 is not a function but a literal date expression which could be interpreted as a date format depending on the spreadsheet settings.
• B) =TODAY() is a function that returns the current date. Therefore, unless the current date is 12/14/2014, this will not return the specified date.
• C) =DATE(2014,12,14) is a function that constructs a date from the provided year, month, and day values, so it would return 12/14/2014 as expected.
• D) 12/14/2014 without an equals sign is generally recognized as a date literal in spreadsheets and would be displayed as 12/14/2014 if it aligns with the spreadsheet's date formatting settings.

The function that will not return the date 12/14/2014 is option B) =TODAY(), as it returns the current date, which is constantly changing and would only be 12/14/2014 on that specific day.