**Calculate Number of Days in Excel:** In this article, we will explain how to calculate the number of days between starting and end date in Microsoft Excel. Below we discussed finding the days between two dates within the same year and the different year in Excel.

## Jump To:

**Find the days between 2 dates without function****Find the days between 2 dates with DATEDIF function****Verdict**

## How to Find the days between 2 dates without function:

It is possible to find the days between the 2 different dates in the same year or a different year. Below we considered a sample scenario will help you understand clearly about finding the days between the dates.

From the above image, you can able to see the starting date as “**23-Jan-19**” and the ending date as “**29-Aug-19**“.

- Select the cell “B3” to print output
- Now you need to use the simple formula

**=B2-B1+1**

- Copy the above formula and paste it in the cell “
**B3**” to find the days

- Execute the formula and it will print the days in the cell
**B3**.

From the above image, The **219** days is the difference between the **starting date** and the **ending date**. You can use this method for a single time purpose and if you have many dates we suggest you need to use the function to reduce repetitive work.

## Find the days between 2 dates with DATEDIF function:

You can use the **DATEDIF** function to find the days between the **two different dates, different months and different years**. This is the second method to find the days in Excel. Follow the steps mentioned below:

The DATEDIF function is mainly used to find the days between the days, months and years. The basic syntax of the DATEDIF function is,

The DATEDIF function contains 3 basic arguments and they are:

**Starting Date****Ending Date****Interval Unit**

The interval unit is mainly used to **find the days “D”**, **find the complete month “M”** & **find the complete years “Y”** between the two dates.

Let us consider a sample scenario,

- To calculate the days & then use the below formula,

**=DATEDIF(A2,B2,C2)**

Place the cursor on the output cell “**D2**“, copy the above formula and paste it on the output cell and execute it to find the days.

- To calculate the months & then use the below formula,

**=DATEDIF(A3,B3,C3)**

Place the cursor on the output cell “**D3**“, copy the above formula and paste it on the output cell and execute it to find the months.

- To calculate the years & then use the below formula,

**=DATEDIF(A4,B4,C4)**

Place the cursor on the output cell “**D4**“, copy the above formula and paste it on the output cell and execute it to find the years.

- To calculate the months after the current year & then use the below formula,

**=DATEDIF(A5,B5,C5)**

Place the cursor on the output cell “**D5**“, copy the above formula and paste it on the output cell and execute it to find the months after the current year.

- To calculate the days after the current year & then use the below formula,

**=DATEDIF(A6,B6,C6)**

Place the cursor on the output cell “**D6**“, copy the above formula and paste it on the output cell and execute it to find the days after the current year.

- To calculate the days after the current month & then use the below formula,

**=DATEDIF(A7,B7,C7)**

Place the cursor on the output cell “**D7**“, copy the above formula and paste it on the output cell and execute it to find the days after current month.

## Verdict:

That’s it. As we said, we explained the two different ways to find the number of days between the months, days and years. If you have any queries and then feel free to comment us below. Find more excel based articles on:

An article explaining how to calculate the number of days between the two dates which includes days, months and years in Microsoft Excel.

## Comments

0 comments