Manually calculating only working days between two dates can be a pain. Microsoft Excel has a great function to ease your job of doing this. Here’s how you calculate only weekdays between dates in Excel using Excel function.
Usually, when doing some calculation for attendance or works related, we might want to exclude those weekend days. With the following Excel functions, you can automatically calculate only the weekdays between two distinct dates.
See also how to calculate between dates in Excel.
How to calculate weekdays between dates in Excel
- On your Excel sheet, put any two dates that you want to calculate in two separate cells.
- Highlight the cell where you want the answer to be displayed.
- Enter the formula as follows (example as in image above) and hit Enter.
Alternatively, you can enter the two dates in the formula. Here’s how to do it:
- Enter the formula as follows and hit Enter.
Done. Are these formulas useful?
That’s it. If you have any suggestions please let me know in the comment below.