Subscribe Now!

How To Calculate The Number Of Workdays Between Two Dates Using NETWORKDAYS in MS Excel

MS EXCEL LOGO
By BJ Johnston

Is is easy in Excel to calculate the number of working days between two dates. Most, but not all businesses, operations or project activities and progress happen during weekdays. So, if you need to report and calculate the number of days that have elapsed between a start date and an end date of a project or project milestone for example then counting weekends in the calculation is not what you want to do, and you will need to avoid those days in your calculations. It is easy to do in Excel with the NETWORKDAYS function.

The formula NETWORKDAYS is pretty straightforward and has two required arguments or parts to it.

The syntax of the formula is

=NETWORKDAYS(start_date,end_date)

So, an example always helps when working through Excel formulas.

Below is the start date and end date of a short project. Start Date is in cell C4 and End Date is in D4.

01/01/2015-Start Date

31/03/2105-End Date

The formula calculates the number of workdays (excluding Saturdays and Sundays which is the default), in this example it is 64 days.

So, this is a straightforward calculation automatically excluding Saturdays and Sundays, but some projects could and do include Saturdays, Sundays or even both.

Well of course Excel can handle this. In this instance we can use the NETWORKDAYS.INTL function.

The difference with this formula this is that it includes an extra argument or part, a weekend code, which allows us to specify which days to exclude as a weekend day or days. The syntax of this formula is

=NETWORKDAYS.INTL(start_date,end_date,weekend)

Let’s apply the same formula- but let’s assume we know our project work was active on Saturdays also. So, we need to ensure exclude any Saturdays from the calculation of days worked on our project

So, we need to select option 17 which is Saturday only. You can choose any of the options of 1 to 17 from the drop down menu. This now increases our work days to 77 days in the period 01/01/2015 to 31/03/2015 as Saturdays are now included as normal working days and should increase the number of days worked on our project. The number of days between the two dates now increases to 77 workdays.

The NEWTWORKDAYS and NETWORKDAYS.INTL are a useful couple of Functions to have in your Excel Tool Kit.

BJ Johnston has been an advanced Excel user for 15 years and is the creator of http://www.howtoexcelatexcel.com a site that shares Excel tips and tricks with it’s enthusiastic members.

Share

Proposal Planning and Writing for RFPs: Write Great Proposals to Win U.S. Government Contracts

6-5-2015 2-31-32 PM

Proposal Planning and Writing for RFPs” is a 51-page (8.5” x 11”) comprehensive volume describing in over 10,000 words every aspect of responding to a government RFP (Request For Proposal).

This e-book even covers the questions that need to be asked to decide whether an RFP is the correct one, way before the prosal writers type the first word on their keyboards.

Government proposal writing is a fast changing field and thus RFP how-to guides need to be updated on a regular basis. This edition includes the latest developments and references in the field.

Proposal Planning and Writing for RFPs” is researched, developed and written over a 6 month period with the following two groups of audiences in mind:

1) BUSINESS and TECHNICAL WRITERS assigned to write a proposal in response to an RFP. There is plenty in here to guide a writer from start to finish, including a detailed description of every component that a good proposal needs to have.

2) PROJECT MANAGERS whose jobs are much harder since not only they need to hire and direct the RFP writers, but they also must first evaluate if the RFP is actually the right one. If that research yields a positive result, then they need to shoulder the even more ardous task of putting together an RFP project team and driving the delicate process to its very end. This ebook also has chapters exclusively written for such project managers.

The main chapters are:

1) Introduction and Terminology

2) Six Set-Aside Programs (for small businesses)

3) Subcontracting facts

4) GSA Schedules

5) Focus on Selected Agencies and Resources

6) First Things First – the things you need to do to start the process

7) Questions to ask BEFORE you start to write your proposal

8) Questions to ask BEFORE you start to send out your proposal

9) Parts of the proposal

10) 5W + H Reality Check

11) Watch Out for the “Fishing Expeditions”

12) Step-by-Step Reply Process for RFP Managers

13) RESOURCES: U.S. Federal Procurement Web Sites (69 web sites)

14) RESOURCES: U.S. State & Local Procurement Web Sites (71 web sites)

15) GLOSSARY

Chapter 13 is a unique chapter: it describes a step-by-step development process for the proposal management team, starting with the assignment of responsibilities and selection of work teams all the way to writing the final draft and bringing the project to a successful conclusion.

The updated and alphabetized list of 140 federal and state procurement web sites in the resource chapters alone is worth the modest price of this comrehensive guide.

Those two chapters alone can save you untold hours of searching for the appropriate resources. Knowing where those web sites are important to find the right RFP or project bid. Now you have them all under your finger tips in two convenient lists.

Proposal Planning and Writing for RFPs” is recommended for all business teams, project managers, business and technical writers, and all those who would like to get their share from the annual $500 billion U.S. federal procurement pie.

Share

AP Style Quiz Book: 150 Questions with Answers to Test your AP Stylebook Knowledge

51pnr5UEeYL._BO2,204,203,200_PIsitb-sticker-v3-big,TopRight,0,-55_SX278_SY278_PIkin4,BottomRight,1,22_AA300_SH20_OU01_

AP_Style_R1

AP_Style_R4

Share