DAY Function Explained

The DAY() function in Microsoft Excel returns the day of the month as a number from 1 to 31, given a date value. It takes a single argument, which is a date value, and returns a number from 1 to 31.

DAY Function Syntax

DAY(serial_number)

  • serial_number: A number in the date-time code used by Microsoft Excel, or a reference to a cell containing a date or date-time code.