Which of the following is not a valid date formula?

Question

BlackTom AI · Accepted Answer

Date functions return specific parts of a date value (year, month, day) or compute positional values (weekday number), but there is no standard spreadsheet function literally named WEEKDAYNAME.

1) Relevant knowledge points and concepts
- Common spreadsheet date functions: YEAR(date) extracts the year, MONTH(date) extracts the month number, DAY(date) extracts the day of the month, and WEEKDAY(date) returns the weekday as a number (usually 1–7 depending on system).
- To get a weekday’s text name (e.g., "Monday"), spreadsheets use TEXT(date,"dddd") or a combination like CHOOSE(WEEKDAY(date),"Sunday",...) rather than a built-in named function WEEKDAYNAME in mainstream spreadsheets (Excel, Google Sheets).

2) Step-by-step reasoning
- Check each option for existence in common spreadsheet environments (Excel/Google Sheets):
  - =year(): exists. Example: =YEAR("2021-12-25") returns 2021.
  - =month(): exists. Example: =MONTH("2021-12-25") returns 12.
  - =day(): exists. Example: =DAY("2021-12-25") returns 25.
  - =weekdayname(): no standard built-in function with this exact name in Excel or Google Sheets.

3) Intermediate demonstrations
- YEAR("2021-12-25") → 2021
- MONTH("2021-12-25") → 12
- DAY("2021-12-25") → 25
- To obtain a weekday name instead of a WEEKDAYNAME function, use TEXT("2021-12-25","dddd") → "Saturday" or CHOOSE(WEEKDAY("2021-12-25"),"Sunday",...).

4) Why the correct answer is correct
=weekdayname() is not a valid built-in date formula in standard spreadsheet software; the task of producing the weekday name is achieved through other functions (TEXT or CHOOSE + WEEKDAY). Hence =weekdayname() is not valid.

5) Why the other options are incorrect (i.e., why they are not the answer)
=year(), =month(), and =day() are valid and standard date-extraction functions, so none of them is the invalid option.

Conclusion: The invalid/unrecognized formula is =weekdayname(), matching the provided correct answer.

Which of the following is not a valid date formula?单项选择题

类似问题

Select the correct function to return month from a date:Date: 27-Feb-2023Result: 2

Which of the following is not a date function? ____ a. YEAR c. AND b. NOW d. TODAY

Question at position 8 An excess of growth hormone (GH) before puberty can result in the development ofgigantism.Graves' disease.acromegaly.pituitary dwarfism.Clear my selection

Question at position 6 The most abundant supporting cells in the central nervous system are called Question Blank 1 of 1[input].

Question at position 5 In the eye, the lens functions tofocus light on the retina at the back of the eye.protect the surface of the eye.increase vision in low-light conditions.move the eye side to side.Clear my selection

Question at position 4 Olfactory (odor) receptors are chemoreceptors. TrueFalse

If the pKa of HCHO2 is 3.74 and the pH of an HCHO2/NaCHO2 solution is 3.00, which of the following is TRUE?

Identify the missing particle in the following nuclear equation: 92 236 𝑈 → 38 90 𝑆 𝑟 + ? + 2 0 1 𝑛 + 4 0 0 𝑔

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单