Calculate the Difference Between Two Dates in Excel, Know Step By Step Guidance | 2022

Excel users have to organize the start and end dates in the sheet. However, many users do not know how to calculate days between two dates in excel. Scan this guide that illustrates four different formulas to find the difference between two dates in the spreadsheet.

Microsoft Excel Summary

MS Office includes Excel, a spreadsheet program, to facilitate mathematical calculations, graphs, pivot tables, charts, Visual Basic language, etc. Microsoft created Excel for Android, iOS, Windows, and MacOS.

calculate days between two dates in excel

Some crucial functions used in the Excel sheet include SUM, VLOOKUP, AVERAGE, CONCATENATE, etc. Professionals like auditors or bookkeepers, sellers, data consultants use Excel.

Directions to Calculate Days Between Two Dates in Excel

To calculate days between two dates in excel, use formulas like DATEDIF, DATE, NETWORKDAYS, and DAYS360 discussed below. Further, we have explained steps to find the difference in weeks, months, years between two different dates in the Excel sheet using the DATEDIF function.

Function 1: Use DATEDIF Syntax: (start_date, end_date, unit)

One of the easiest formulas to compute the days between two different dates in Excel is DATEDIF. Chase the below steps to calculate days between two dates in excel using DATEDIF:

  1. Firstly, type in the start date in cell D9, for example, (1/1/2014).
  2. Next, in E9, enter the end date (5/6/2016).
  3. In the Function Bar, use the formula =DATEDIF(D9, E9,”d”) for calculation.
  4. Finally, you will get the result in F9.

calculate days between two dates in excel

Weeks Difference Calculation via DATEDIF:

  1. Firstly, type in the start date in cell D13, for example, (1/1/2014).
  2. Next, in E13, enter the end date (5/6/2016).
  3. Finally, in the Function Bar, use the formula =DATEDIF(D13, E13,”d”)/7 to get the result.

calculate days between two dates in excel

Months Difference Calculation via DATEDIF:

  1. Firstly, type in the start date in cell D5, for example, (1/1/2014).
  2. Next, in E5, enter the end date (5/6/2016).
  3. Finally, in the Function Bar, use the formula =DATEDIF(D5, E5,”m”) to obtain the answer.

Years Difference Calculation via DATEDIF:

  1. Firstly, type in the start date in cell D2, for example,(1/1/2014).
  2. Next, in E2, enter the end date (5/6/2016).
  3. Finally, in the Function Bar, use the formula =DATEDIF(D2, E2,”y”) to calculate days between two dates in excel.

Function 2: Use DATE Syntax: =DATE(yyyy, m, d)-DATE(yyyy, m, d)

The second function to calculate the difference between two dates is DATE. For that, type in the dates in the Function Bar directly.

Note: Enter the end date first. Afterward, type in the start date in the Function Bar.

  1. Firstly, assume the start date as 4/1/2017 and the end date as 5/5/2017.
  2. Next, in the Function Bar, enter =DATE(2017, 5, 5)-DATE(2017, 4, 1). Hit the Enter key.
  3. Finally, the result (34) arrives instantly in a click.

calculate days between two dates in excel

Note: If the result appears in the Date format, modify it. Simply right-tap on the answer cell (34) and click on the Format Cells option. Select General and hit Ok.

Function 3: Use DAYS360 Provided Within Formulas Tab

The DAYS360 formula helps in finding dates difference within a financial year. Seek the below process to calculate days between two dates in excel via DAYS360:

  1. Firstly, type in the start date (1/1/2016) in B6.
  2. Next, enter the end date (1/1/2017) in C6.
  3. Select a cell to calculate the difference (Total Days) (for example, select D6).
  4. After that, tap on Formulas —> Date & Time —> DAYS360.

  1. A Function Arguments window arrives. In the Start_date, type in B6, and the End_date, enter C6.

2. Finally, press the OK button. You will get the result.

Function 4: Use NETWORKDAYS Syntax: =NETWORKDAYS(start_date, end_date, [holidays])

The NETWORKDAYS function helps find the differences between the two dates, excluding the weekends and holidays. To apply it, track the below actions:

  1. Firstly, type in 18/1/2020 as the Start Date in cell A4.
  2. After that, in B4, enter the End Date: 17/2/2020.
  3. Enter the Holidays date in different cells. For example, assume 13/2/2020 and 14/2/2020 as holidays.
  4. Now, choose cell D6 for computation.
  5. Go to Formulas —> Date & Time —> tap NETWORKDAYS.
  6. Type in the Start_date, End_date, and holidays.
  7. Finally, hit on the Ok button to get the answer.

Bitly Windowstxt: How To Activate It On PC? More Info About It

Summing-up

These are the few methods to calculate days between two dates in excel. Hence, use them to find the total number of days between two dates in a click. I likewise trust you preferred the article and assembled data subsequent to understanding it. Leave your remarks or inquiries down the article. Thank You for visiting our website techmoj.com

Leave a Comment

Your email address will not be published.

Scroll to Top