Which MS Excel function (or combination of functions) can be used to determine the number of weekdays between two specific dates?
Question
Which MS Excel function (or combination of functions) can be used to determine the number of weekdays between two specific dates?
Solution
To determine the number of weekdays between two specific dates in MS Excel, you can use the NETWORKDAYS function. Here's how to do it:
- Click on the cell where you want the result to be displayed.
- Type
=NETWORKDAYS(. - Click on the cell that contains the start date, or type the start date in quotes using the format "yyyy-mm-dd".
- Type a comma
,. - Click on the cell that contains the end date, or type the end date in quotes using the same format.
- Close the parenthesis
). - Press Enter.
The result displayed will be the number of weekdays (Monday-Friday) between the two dates, excluding weekends.
Similar Questions
This formula in data validation only accepts Tuesday as the day of the week: =weekday(A1)=2 True False
3. What day follows the day before yesterday if two days from now will be Sunday?MondayTuesdayWednesdayThursdayFridaySaturdaySunday
If 2nd of the month falls on the day preceding Monday, on what day will 31st of the month fall?OptionsMondaySaturdayFridaySunday
Can you provide the excel formula how to count the daily traffic and average ticket price?
If today is a Sunday after 147 days it will be? a. Friday b. Sunday c. Monday d. Tuesday
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.