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;

=NETWORKDAYS("01/01/2010","31/12/2010")

Calculating working days really is that easy!

487 thoughts on “Calculate Working Days Between two Dates

  1. App Controle Mxq 4K

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. news credit

    Wow! This can be one particular of the most useful blogs We ave ever arrive across on this subject. Basically Magnificent. I am also an expert in this topic therefore I can understand your hard work.

  3. o2tvseries download

    Very nice article and straight to the point. I am not sure if this is truly the best place to ask but do you folks have any ideea where to employ some professional writers? Thank you

  4. J. river media center 12.0.106 flac pkg

    Hi there very cool site!! Guy .. Excellent .. Superb .. I will bookmark your blog and take the feeds also? I am glad to search out numerous useful information here within the publish, we need develop extra techniques in this regard, thanks for sharing. . . . . .| а

Comments are closed.