---
title: Using the Days Function in Excel 2013
description: Microsoft Excel 2013 has a new useful function called Days. If you give it an end date and a start date, it will display the total number of days between the two dates. Follow these easy steps to create the function.
---

[KnowledgeWave Blog ](https://www.knowledgewave.com/blog)

# [Using the Days Function in Excel 2013](https://www.knowledgewave.com/blog/using-the-day-function-in-excel-2013)

 Written by [David Thibault](https://www.knowledgewave.com/blog/author/david-thibault) | December 14, 2015

Microsoft Excel 2013 has a new useful function called **Days**. It is pretty easy to use and only requires two arguments: an end date and a start date. The results will be displayed as the total number of days between the two dates. Follow the steps below to create the function.

1. **Click in the cell** you would like to return the answer in.

2. Click on the **FX Insert Function button** located on the Formulas tab (can also be found next to the formula bar).

3. This opens up the **Insert Function Dialog box**. Type the word **Days** in the search box and click **Go**.

4. **Select** the **Days function** under Select a Function then click **OK**.

5. In the **Function Arguments Dialog box** either **enter** manually the **End Date and Start Date** or click on the appropriate cells.

6. Click **OK** when done.

7. The formula result will be displayed as the total number of days between the two dates.

Here is what the formula looks like: =DAYS(H2,G2).

To find the number of years, simply divide by 365: =DAYS(H2,G2)/365.

 

If you liked this tip, be sure to check out our FREE video on 10 AHA! Moments in Microsoft Excel.

[View full post](https://www.knowledgewave.com/blog/using-the-day-function-in-excel-2013)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "David Thibault"
  },
  "dateModified" : "2015-12-14T18:37:19.002Z",
  "datePublished" : "2015-12-14T18:37:00Z",
  "headline" : "Using the Days Function in Excel 2013",
  "image" : {
    "@type" : "ImageObject",
    "height" : 565,
    "url" : "http://www.knowledgewave.com/hubfs/blog_images/iStock_calendar_days.jpg",
    "width" : 849
  },
  "mainEntityOfPage" : "https://www.knowledgewave.com/blog/using-the-day-function-in-excel-2013",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "KnowledgeWave Blog"
  }
}
```