This formula in data validation only accepts Tuesday as the day of the week: =weekday(A1)=2 True False

A cell cannot be formatted to only accept dates that are weekdays True False

Define a function named is_valid_day() which takes no parameters. The function prompts the user to enter a date and validates the day value only. The function returns True if the day value is within the specific range based on the particular month, and returns False otherwise. The months and their corresponding number of days are listed below:January, March, May, July, August, October, December: 31 days.February: 29 days (we consider a leap year for all cases).April, June, September, November: 30 days.For example:Test Input Resultprint(is_valid_day())2002-02-30Enter your birth date (yyyy-mm-dd): 2002-02-30Falseprint(is_valid_day())2003-04-31Enter your birth date (yyyy-mm-dd): 2003-04-31Falseprint(is_valid_day())2005-07-31Enter your birth date (yyyy-mm-dd): 2005-07-31True

Which of the following functions returns the day of the week from a given date in Excel? Answer( Please choose a correct answer )   CLEARDAY()WEEKDAY()MONTH()YEAR()

Write a function 'returnDay' that takes one parameter(number from 1 to 7) and returns the day of the week.(where 1 is Monday, 2 is Tuesday, 3 is Wednesday, etc).If the number is less than 1 or greater than 7, the function should return null.Note: Store the days of the week in the array.

This formula placed in data validation will only accept values greater than the cell above it: =A1>A2 True False