This is a new function introduced in Excel 2013. This function is used to return the number of days between two dates; in other words, between an end date and a start date. The syntax of using this function is =DAYS(end_date,start_date). This function is not available in Excel 2010. The end_date specifies the end date and start_date specifies the start date. This function is useful when we want to determine the number of days between two dates.
Let's have a look at the following steps.
Step 1
First go to Excel 2013.
Step 2
Now select blank workbook templates from the available templates.
![days-function-in-excel2013.jpg]()
Step 3
Now enter a start date and an end date of which we want to determine the number of days between, like this:
![excel2013-days-function.jpg]()
Step 4
Now enter the following formula to determine the number of days:
![excel2013-with-days-function.jpg]()
Step 5
The output will be like this:
![use-of-days-function-in-excel2013.jpg]()