Calculate Working Days Between two Dates

Excel has an inbuilt function that allows you to work out the number of working days between two dates.

In fact, it is just calculate-working-daysas simple as working out the total number of days between two dates. So this is extremely useful in a business environment as the calculations remove the weekends from the total number of days.

Calculating Working Days in Excel

To calculate the number of working days, select a cell and then type the following

=NETWORKDAYS(First Date,Last Date).

Then hit enter. In the formula, where it says First Date you must enter a cell reference, for example A1.  Where it says Last Date, you must enter the cell reference that contains your last date, for example B1.

But, you can also enter dates manually within the formula.  For this to work the dates must be within ” marks.  For example, to work out the number of working days for the whole 2010 using dates entered manually your formula should like this;


Calculating working days really is that easy!

One thought on “Calculate Working Days Between two Dates

  1. EsmeraldaJuicy

    Hi. I see that you don’t update your blog too often. I know that writing content is boring and time consuming.
    But did you know that there is a tool that allows you
    to create new articles using existing content (from article directories or other blogs from your niche)?

    And it does it very well. The new posts are high quality and
    pass the copyscape test. You should try miftolo’s tools

Leave a Reply

Your email address will not be published. Required fields are marked *