Go Back

Learn How to Use the DAYS Function in Excel

Read time: 15 minutes

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.

Formula Syntax

=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;

  1. 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.

  1. 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.

  1. 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.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

How to calculate number of days between two dates
Solved by M. U. in 11 mins
I need All dates between 1-59 days highlighted in pink and all dates 60 days and older highlighted in Red.
Solved by A. A. in 20 mins
when i subtracted 2 dates together to get the days in between it gave me 1/12/00 i don't know what that means
Solved by G. Y. in 24 mins

Leave a Comment