One of the tasks I have been asked very early in my excel job is to calculate or count workdays between dates.

Should be easy right?
So let’s take a look at a date in excel.
Dates in excel are strange things. When you copy them as values they come up as numbers.

That is actually very handy because if you want to add or remove a day from a date you can just add or subtract one.

What about the weekends? What if I only need to count workdays?

You can use the NETWORKDAYS formula!

What does the NETWORKDAYS formula do?

It gives you the number of workdays between two dates.

What does the NETWORDAYS formula need?

=NETWORKDAYS(start_date,end_date,[holidays])

The formula only need two things to function.
-A Start Date
-An End Date
As an option we can add holidays even as an array.

That is very handy. If you have a settings sheet where you have your non working days collected in an array you can have the NETWORKDAYS formula to count with those days.

Excel Networdays formula in action
Excel networkdays formula

Here above an example, how you can use the formula. With or without the holidays option.

ExcelAngel has a facebook page. Come and give us a thumbs up. it helps a lot.
You can also find a lot more in our Excel basics category

[et_pb_ccfcm_facebook_comments_module ccfcm_app_id=”339898187197719″ _builder_version=”4.6.1″ _module_preset=”default”][/et_pb_ccfcm_facebook_comments_module]