# DAY

## Content

This function returns the day number of the month (integer 1 to 31) that corresponds to the specified date.

## Syntax

`DAY( date )`

## Arguments

Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in `DATE(2003,7,4)`.

## Data Types

Accepts numeric, string, or DateTime object data. Returns numeric data.

## Examples

`DAY(A2)`

`DAY(R2C1)`

`DAY(366778)` gives the result 14.

`DAY(33239)` gives the result 1 (because 33239 is the value for January 1, 1991).

`DAY("7/4/2003 12:00")`

`DAY(DATE(2003,7,4))`