The Excel DAY function returns the day of the month as a number between 1 to 31 from a given date. You can use the DAY function to extract a day number from a date into a cell. You can also use the DAY function to extract and feed a day value into another function, like the DATE function.
Syntax
The syntax for the DAY function in Microsoft Excel is:
=DAY( date_value )
Parameters or Arguments
date_value
A valid date to return the day of the month.
Day Function Examples
Column B of the following spreadsheet shows the Excel Day function, used to extract the day from three different dates.
Formulas:
Results:
