Excel DAYS Function

HomeExcel FunctionsExcel DAYS Function (Example + Sample File)


The Excel DAYS Function is listed under Microsoft Excel's Date Functions category. It returns the difference between two dates. It takes a start date and an end date and then returns the difference between them in days. This function was introduced in Excel 2013 so not available prior versions.

How to use it

To learn how to use the DAYS function in Excel, you need to understand its syntax and arguments:




  • start_date: It is a valid date from where you want to start the days calculation.
  • end_date: It is a valid date from where you want to end the days calculation.


  • Both start_date and end_date should be a valid date and should be within the range of valid dates. Excel accepts dates that are from 1900 to 10000 years.


To master DAYS function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have referred the cell A1 as the start date and B1 as the end date and we have 9 days in the result.

Note: You can also use the subtract operator to get the difference between two dates.

In the below example, we have directly inserted two dates into the function to get the difference between them.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.