---
url: /cube-functions/day.md
description: Returns the day of the month, a number between 1 and 31, from a given date.
---

# DAY 

Returns the day of the month, a number between 1 and 31, from a given date.

```js
DAY(date)
```

#### Parameters

* `date` - The date for which to return the day of the month, represented as an Excel date value.

#### Examples

```js
DAY("2022-04-17")

```

**Result:** `17`

**Note:** Returns the day of the month (17) from the given date (2022-04-17).

```js
DAY(45033)

```

**Result:** `17`

**Note:** Returns the day of the month (17) from the given date (45033), represented as an Excel serial number.