The DAYS function is a simple date function that lets you calculate the number of days between two dates. The same result can arrived at by simply subtracting two dates such as: `="7/31/2016"-"6/5/1991"`

.

## Purpose

The DAYS function returns the number of days between two dates.

## Related functions

DATEDIF – Calculate length of time between two dates in years, months, and/or days.

MINUS – Subtract one value from another. Can be done with dates.

## Errors

`#NUM` – The inputs are numbers but are not valid dates. This could happen if you used the 35th day of November, “11/352018”.

`#VALUE!` – The inputs are something that doesn’t convert to a number such as “The other day” or “Yester-yester-day”.

## Syntax

`=DAYS(end_date,start_date)`

Note that, for some reason, the function wants the ending date first, then the starting date.

## Video Explanation

## Examples

A few simple examples of the DAYS function.

Formula | Description | Result |

`=DAYS("7/31/2017","7/30/2016")` |
Number of days between 7/30/2016 and 7/31/2017 | 366 |

`=DAYS("1/7/2020","12/5/2015")` |
Number of days between 12/5/2015 and 1/7/2020 | 1,494 |

`=DAYS(C3,"2/9/1994")` |
Number of days between 3/5/2001 (assuming that the value was in C3) and 2/9/1994 | -2,581 |

### Live examples in Sheets

Go to this spreadsheet for examples of the DAYS function that you can study and use anywhere you would like.