---
title: "Use the DAYS Function to Calculate Number of Months Between Dates"
slug: "days-function"
description: "Learn to calculate time intervals with DAYS by finding the number of days between two Dates."
updated: 2025-05-30T09:43:45Z
published: 2025-08-22T11:59:25Z
canonical: "kb.pigment.com/days-function"
---
> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.
# DAYS function
## Description
Returns the number of days between two Dates.
## Syntax
`DAYS(Start Date, End Date)`
## Arguments
| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Start Date* (required) | Date | Any Dimensions | |
| *End Date* (required) | Date | No Dimension or Dimensions of *Date From* | |
## Returns
| Type | Dimensions |
| --- | --- |
| Integer | Dimensions of argument *Start Date* |
## Examples
| Formula | Result | Description |
| --- | --- | --- |
| `DAYS(DATE(2020, 12, 02), DATE(2020, 12, 03))` | 1 | There is 1 day between December 2th 2020 and December 3rd 2020. |
| `DAYS(DATE(2020, 12, 02), DATE(2021, 02, 28))` | 63 | There are 63 days between December 2th 2020 and February 28th 2021. |
## See also
Excel: [DAYS](https://support.microsoft.com/en-us/office/days-function-57740535-d549-4395-8728-0f07bff0b9df)
Related articles: [NETWORKDAYS](/v1/docs/networkdays-function)
> [!TIP]
> **More of a hands-on learner?**
>
> Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!