How to Calculate Number of Days in Microsoft Excel

In this article we will learn about how we can calculate the number of days in Microsoft Excel 2010 and Microsoft Excel 2013.

Often we need to calculate the number of days between two dates.

If these dates get frequently changed then a formula is required to avoid repetitive work.

Let us take an example:

Consider Today is 1-Aug-14
If 1-Jan is first & 2-Jan is second day of the year,then find out Today’s Day of the current year

Take another example:

Column A& B contain Start & End Date and Column C contains Interval Unit. In column D, output is required on the basis of Interval Unit

In this example, we will use Datedif Function. This function can calculate the number of days between two Dates.

Datedif function is used to calculate interval between two dates in days, months or years.

Syntax =DATEDIF(start_date, end_date, interval_unit)

Datedif Function has 3 arguments:

start_date: The starting date
end_date: The last date
interval_unit: Tells the function to find the number of days ("D"), complete months ("M"), or complete years ("Y") between the two dates.
To calculate Number of Days,enter the formula in Cell D2=DATEDIF(A2,B2,C2)