DAY Function in Excel – Get day from date in Excel

DAY Function in Excel returns the day part of the date, when date is given as an input. DAY Function in Excel takes date input in the form of

Reference to cells containing dates
Date Serial numbers
Date values returned from other Excel formulas
Date as a text input

Syntax for DAY Function in Excel

DAY (date)

date – A date from which day is to be extracted

Example of DAY Function in Excel

Formula:

DAY Function in Excel 1

Row number 2 and 3 are Reference to cells containing dates
Row number 4 is date serial number
In Row number 5, date is given as a text input
In Row number 6, date values are returned from DATE Formula

Result:

DAY Function in Excel 2