Reader Level:

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:




Spire.Doc - Free .NET Word API
Use Spire.Doc to create, read, write, print, and convert word documents to OpenXML, RTF, TXT, XPS, EPUB, EMF, HTML, Image and PDF.

Trending up