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

previous-small DAY Function in Excel                                                                                                                next_small DAY Function in Excel