DAY

Definition of DAY

Returns the day of the month that a specific date falls on, in numeric format.

Sample Usage

DAY(DATE(1969,7,20))

DAY(A2)

DAY(40909)

DAY("7/20/1969")

Syntax

DAY(date)

• date - The date from which to extract the day. Must be a reference to a cell containing a date, a function returning a date type, or a number.

Notes

• Ensure that the input to the function is either a reference to a cell containing a date, a function which returns a date object such as DATE, DATEVALUE or TO_DATE, or a date serial number of the type returned by the N function.

• DAY does not autoconvert number formats. Therefore, DAY(10/10/2000) is interpreted as DAY(0.005), the quotient of 10 divided by 10 divided by 2000.

• DAY returns the intuitive understanding of the day of the month, and is useful primarily in other calculations rather than to extract the day of month from a known date, as that value is easily known from reading the entire date.

See Also

YEAR: Returns the year specified by a given date.

WEEKDAY: Returns a number representing the day of the week of the date provided.

TO_DATE: Converts a provided number to a date.

SECOND: Returns the second component of a specific time, in numeric format.

N: Returns the argument provided as a number.

MONTH: Returns the month of the year a specific date falls in, in numeric format.

MINUTE: Returns the minute component of a specific time, in numeric format.

HOUR: Returns the hour component of a specific time, in numeric format.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a provided year, month, and day into a date.

In order to use the DAY formula, start with your edited Excellentable:

Then type in the DAY Formula in the area you would like to display the outcome:

By adding the values you would like to calculate the DAY formula for, Excellentable will generate the outcome: