Durations between dates how to#

Excel understands dates in many formats, for example '2', '', '0', etc. For example, the following formula counts the number of days between the dates in cells A1 and B1: =DATEDIF(A1, B1, 'd') In your DATEDIF formulas, you can input the dates is various ways, such as: To put it differently, start_date and end_date are two dates to calculate the difference between. Start_date - the initial date of the period you want to calculate.Įnd_date - the ending date of the period. Date & Time Wizard - easy way to build date difference formulas in Excel.Date difference in days, months and years.Calculate number of months between two dates in Excel.Count the numbers of weeks between the dates.Get the number of days between two dates.

Excel DATEDIF function - syntax and uses.

In this tutorial, we will focus on calculating date difference in Excel and you will learn different ways to count the number of days, weeks, months and years between two dates.

Durations between dates how to#

If you have been following our blog series, you already know how to insert and format dates in your worksheets, how to calculate days, weeks, months and years as well as add and subtract dates. Over the past few weeks, we investigated nearly every aspect of working with dates and times in Excel. In this tutorial, you will find a simple explanation of the Excel DATEDIF function and a few formula examples that demonstrate how to compare dates and calculate the difference in days, weeks, months or years.