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

img1

  • Subtract Start Date from Today’s Date & then add 1

img2

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

img3

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)

img4

  • To calculate Number of Months,enter the formulain Cell D3=DATEDIF(A3,B3,C3)

img5

  • To calculate Number of Years,enter the formula in Cell D4=DATEDIF(A4,B4,C4)

img6

  • To calculate Number of Days after current year,enter the formula in Cell D5=DATEDIF(A5,B5,C5)

img7

  • To calculate Number of Days after current Month,enter the formula in Cell D6=DATEDIF(A6,B6,C6)

img8

  • To calculate the Number of Month after current year,enter the formula in Cell D7=DATEDIF(A7,B7,C7)

img9

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube