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:
- 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