The Excel DAY Function

Home » Excel-Built-In-Functions » Excel-Date-And-Time-Functions » Excel-Day-Function Search this site: Custom Search

Related Functions:  MONTH Function YEAR Function DATE Function

Basic Description

The Excel DAY function, when supplied with a date, returns an integer representing the day of the month (from 1 - 31).

where the date argument can be supplied to the function as either :

• A date returned from another formula or function

• A references to a cell containing a date

Warning: If you attempt to input the date argument as text, there is a chance that Excel may misinterpret this, due to different date systems, or date interpretation settings.

Also note that, although you can input the date argument as a serial number, this is not recommended, as the serial numbering may vary across different computer systems.

Day Function Examples

The following example shows the function used to extract the day from 3 different dates. The spreadsheet on the left shows the format of the function and the spreadsheet on the right shows the results for the 3 dates.

Note that, in the above examples, as recommended by Microsoft, the date value is always supplied as either a reference to a cell containing a date, or as a value returned from another function.

Further examples of the Excel Day function can be found on the Microsoft Office website.

Excel Day Function Common Problem