Excel Formulas to Get the Number of Workdays between Two Dates!!

Have you ever needed to count the number of days between two dates in Excel? Sometimes, you just want to calculate the workdays between two dates without considering the weekends and holidays. How could you count them with certain conditions? Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

If you want to find out the number of workdays between two dates, you can use the below formula.

Syntax Explanations:

NETWORKDAYS – The NETWORKDAYS Function returns the number of working days between two dates.

Start_date – It specifies the starting date from your worksheet.

End_date – It represents the end date from your worksheet.

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:

Refer to the below example image.

First, we will enter the input values such as starting date , ending date in Column B and Column C.

Here, we have to find out the total working days between these two input ranges excluding weekends and holidays which is given in Column F.

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.

Bottom-Line:

In this tutorial, we have discussed how to get the total working days between two dates in Excel. I hope that this article is helpful to you. Let me know if you have any doubts regarding this article or any other article on this site.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Also:

How to Find the Last Column of Data in Excel Office 365?

Excel Formulas to Calculate the Quarter from the Given Date ~ Easy Tips!!

How to Find the Last Column of Data in Excel Office 365?

How to Enter a Time in Excel Worksheet? ~ A Useful Guide!!