222k views
3 votes
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

User Aolszowka
by
7.8k points

1 Answer

5 votes

Final answer:

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.

No related questions found

Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.4m questions

12.2m answers

Categories