# DAYS

## Content

This function calculates the number of days between two dates.

## Syntax

`DAYS(end_date, start_date)`

## Arguments

<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">This function has these arguments:</span>

| <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">Argument</span> | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">Description</span> |
| -------- | ----------- |
| *<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">end\_date</span>* | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;"> [Required] The end date, specified as a serial number (e.g., 37806), a string, or a cell reference</span> |
| *<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">start\_date</span>* | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;"> [Required] The start date, specified as a serial number (e.g., 37806), a string, or a cell reference</span> |

## Examples

`DAYS("5/15/11","4/1/11")` give the result 44