Sometimes, we need to know how many specific weekdays between the two dates. How could you count the number of days between two dates in a certain condition? Here, I can talk about some effective methods for you. Let’s jump into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- You can use the below formula to count the weekdays between two dates in Excel.
=SUMPRODUCT(–(WEEKDAY(ROW(INDIRECT(start&”:”&end)))=weekday))
Syntax Explanations:
- SUMPRODUCT – The SUMPRODUCT function multiplies the corresponding arrays or ranges and returns the sum of the products.
- WEEKDAY – It will return a number (ranging from 1 to 7) that represents the day of the week for a given date. Read more on the WEEKDAY function.
- ROW – In Excel, the ROW function returns the row number for a reference.
- INDIRECT – This function helps to return a valid reference from a given text string. Read more on the INDIRECT function.
- Start – It specifies the starting time.
- *End * – It specifies the ending time.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Example:
Let’s consider the below example image.
- Here we will enter the input dates in Column B and Column C.
- Now we are going to count the weekdays between two days given in Column E.
- Select any cell and type the above-given formula.
- Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.
Wind-Up:
From this short tutorial, you can get how to count weekdays between two dates in Excel. If you have any issue regarding this article or any unresolved query , please comment in the comment box below. We will assist you.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
Top comments (0)