Suppose you have a sales data that has an order date column. What dax function that you will use to track the sales made on weekdays and weekends?SELECT THE CORRECT ANSWERWeekday()Date()Weekends()dayofweek()

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

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()

A report needs to show the number of weekdays within a project to estimate capacity. Which function would provide the desired result?Select an answer:WEEKDAYNETWORKDAYSWORKDAYDAYS

Create a short program that uses list_of_days to store a list of the seven days of the week. Ask the user to choose a day of the week by picking a number from 1-7. Print the day in the index position with that number. Use conditionals to display which days are weekdays and which are weekend days.

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.