in ,

ExcelExcel

How to Calculate the Number of Days in Microsoft Excel?

Quickly calculate the number of days in Microsoft Excel!

Calculate Number of days in Excel

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:

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.

Finding Days between the two days
Finding Days between the two days

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
Formula to calculate the number of days
Formula to calculate the number of days
  • Execute the formula and it will print the days in the cell B3.
Output
Output

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,

=DATEDIF(starting_cell, ending_cell, interval_unit)

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,

Sample Scenario
Sample Scenario for DATEDIF function
  • 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.

Output
Output
  • 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.

Output
Output
  • 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.

Output
Output
  • 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.

Output
Output
  • 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.

Output
Output
  • 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.

Output
Output

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.

Article Review
  • Article Explanation
  • Images Explanation
  • Formula Used
4.8

Summary

Find more article on our HomePage

Leave a Reply

Your email address will not be published. Required fields are marked *

Loading…

0

Comments

0 comments