Calculate the Number of days present between two dates in Excel 2010


You can easily calculate the number of days between any two dates in the excel application. You can achieve this task by using the (-) subtraction operator or the "NETWORKDAYS” function of the excel program.


Using the Subtraction operator

Let’s say that, you wish to find out the number of days present in between the two dates 9/2/2010 and 10/2/2011. Then, you type the date 9/2/2010 in cell A1 and the date 10/2/2010 in cell A2. To find the number of days in between these two dates type a formula in cell A3 as =(A2-A1).


Figure 1



Now if you observe, the exact number of days present between the above two mentioned dates will be displayed in cell A3.


Figure 2




Using the NETWORKDAYS Function

You can also use the built-in function called the NETWORKDAYS to find out the number of days between two dates. But, the NETWORKDAYS function will display only the number of Working days between two dates. i.e., it excludes the Holidays that are present between the two mentioned dates.

For example, consider a project that has to be started on a particular date and finished within a particular date. Here, in our example, we intend to calculate the number of working days that are present between the start and the finish date of the project.

The starting date of the project is 9/2/2010 and the last date for the project to be finished is 10/2/2010. Between the dates, there are three National holidays (9/10/2010, 9/15/2010 and 9/25/2010), four Sundays and three Saturdays which are considered as holidays.

Now, to find out the number of working days that the project gets allocated in order to be completed successfully, type the start date in cell C1, the finishing date in cell C2 and the three national holidays in cells C4, C5 and C6 respectively. Type the formula =NETWORKDAYS(C1,C2,C4:C6) in cell C8 to find the exact number of working days between the start date and the finish date of the project.


Figure 3



Now, if you observe the worksheet, the number of working days between the start date and the finish date of the project will be displayed. In our example, the exact number of days between the two dates is 20.


Figure 4



The NETWORKDAYS function contains three arguments

a) start_date, is the date that represents a starting date.

b) End_date, is the date the represents a ending date.

c) Holidays, are the days that are excluded from the normal working days such as federal and national holidays. The list of holiday can be represented in a range of cells as shown in our example.

so, this is how you can calculate the number of days present between two dates in Excel 2010 Application.


See also How to Insert Current Date and Time in Excel 2010 Application


Read Other Applications