How To Calculate Days Between Dates In Excel (Easy Guide)

Calculating days between dates in Excel is a simple process that can be done using built-in functions. These functions help users quickly determine the number of days between two specific dates, making data analysis more efficient and accurate.

In this easy guide, we will walk you through the step-by-step process of calculating days between dates in Excel using a simple function. Whether you are a seasoned Excel user or just getting started, this guide will help you master this essential calculation.

How to Calculate Days Between Dates in Excel with Days Function

The DAYS function provides a simple way to determine the difference between two dates by subtracting the start date from the end date, resulting in the total number of days in between.

Here are the steps to use the DAYS function in Excel:

  1. Open an Excel worksheet and enter the two dates you want to calculate the number of days between them.
  2. Select the cell where you want to display the number of days between the two dates.
  3. Type the following formula into the cell: =DAYS(cell number of end_date, cell number start_date).

    Replace “cell number start_date” with the cell number of the earlier date, which in this example is cell B. Replace “cell number of end_date” with the cell number of the later date, which in this example is cell C.
  4. Press “Enter” to get the result. The result will be displayed in the cell you selected in step 2.


Mastering Excel’s date calculation functions and techniques ultimately lead to more accurate and insightful data analysis, streamlined project management, and enhanced financial assessments. By practicing with real-life examples and continuously exploring new ways to harness the power of Excel, users can significantly elevate their skills and make informed decisions in various professional and personal contexts.