Figure 1. Excel Days Function.
If we want to obtain a number representing days occurring between two specific dates in Excel, we must make use of the DAYS function.
=DAYS (end_date, start_date)
- start_date = A specified date from which Excel begins to count.
- end_date = A specified date where Excel is to stop it’s count.
Determine the total number of days occurring between two dates by using the Excel DAYS function.
How to use the Excel DAYS Function.
Follow the 3 simple steps described below to understand the application of the DAYS Function;
- In our worksheet example below, our purpose is to determine the total number of days between the dates in the START DATE and END DATE columns.
Figure 2. Excel Days Function.
Ensure that you have provided Excel with empty cells to return our desired results.
- The DAYS formula we will type in cell C2 of our worksheet, is;
Figure 3. Excel Days Function.
The Excel Days formula calculated the total number of days occurring between the dates in cells A2:B2, as 365.
- Copy a modified version of the Days formula we used above, down the other cells in the RESULTS column to get the other results.
Figure 4. Excel Days Function.
Even if we define the start and end dates as text in our Days formula syntax, DAYS function will still calculate the number of days between those two dates.
Figure 5. Final Result.
Instant Connection to an Expert through our Excelchat Service:
Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes.