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

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

In cell F13 of the Schedule worksheet, enter a formula that will calculate the total number of employees scheduled to work Sunday for all schedules A-G. Begin by multiplying the number of employees for schedule A, in cell D5, by the value representing whether or not employees are working that day in cell F5. Be sure to make the reference to cell D5 an absolute cell reference so that, when finished, the formula can be copied across the row. So far the result of the formula is 0 because schedule A has people scheduled off on Sunday. Next, add to the product, the number of employees scheduled to work Sunday for schedule B. Continue with the formula by adding a similar calculation for schedules C-G, making an absolute cell reference for each cell in column D.

Why is the DATE function in MS Excel used?ACalculate the number of days between two dates.BConvert a serial number representing a date into a formatted text string.CDetermine the current date and time.DCreate a date value based on individual year, month, and day values.