Reader Level:
Microsoft Office

Days Function in Excel 2013

By Megha Goyal on Sep 05, 2012
In this article we will discuss how to use the days function in Excel 2013.

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.


Step 3

 Now enter a start date and an end date of which we want to determine the number of days between, like this:


Step 4

Now enter the following formula to determine the number of days:


Step 5

The output will be like this: