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 |
|---|---|---|
| 1 | There is 1 day between December 2th 2020 and December 3rd 2020. |
| 63 | There are 63 days between December 2th 2020 and February 28th 2021. |
See also
Excel: DAYS
Related articles: NETWORKDAYS
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!