Returns the day corresponding to a given date.

**Sample Usage**

DAY("7/15/2019")

DAY(C5)

**Syntax**

DAY(date)

- date - The date from which to calculate the day.

**Examples**

DAY("7/15/2019") returns the day component, which is 15.

DAY(C5) returns the day component of the date value contained in C5.

**Notes**

- DAY does not auto-convert number formats. Therefore, DAY(10/10/2000) is interpreted as DAY(0.05) , the quotient of 10 divided by 10 divided by 2000.
- Problems can occur if dates are entered as text. You can use the DATE function to enter a date. For example, use DATE(2020,2,3) for the 3rd day of January, 2020.
- You can also use other functions which return a date object. (For example: DATEVALUE).