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

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

A cell can be formatted to only accept integers 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

Given day of the week encoded as 0 = Sun, 1 = Mon, 2 = Tue, ... 6 = Sat, and a boolean vacation indicating if we are on vacation. Write the function alarm_clock(day, vacation) that returns a string of the form "7:00" indicating when the alarm clock should ring. On weekdays (Mon-Fri), the alarm should be "7:00" and on the weekend (Sat and Sun) it should be "10:00". However, if we are on vacation, then on weekdays it should be "10:00" and weekends it should be "off".Examplesalarm_clock(3, False) -> "7:00"alarm_clock(5, True) -> "10:00"alarm_clock(6, True) -> "off"

Which MS Excel function (or combination of functions) can be used to determine the number of weekdays between two specific dates?