Excel Function : DAY

Download now!

Excel Function : DAY

Category

Date and time

Description

Converts a serial number to a day of the month

Microsoft Excel Reference Page

https://support.office.com/en-us/article/DAY-function-8a7d1cbb-6c7d-4ba1-8aea-25c134d03101

Syntax and Description of the DAY Excel Function

The DAY function in Excel returns the day of the month (a number between 1 and 31) for a given date. The syntax for the DAY function is as follows: =DAY(date) where "date" is a cell reference to a cell containing a date.

About DAY Excel Function

The DAY function returns the day of the month for a given date. The day is given as a number between 1 and 31.