Skip to Content

DAY

Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31

Syntax

DAY(serial_number)

Parameters

  • serial_number: Required. The date of the day you are trying to find

Example

=DAY("15-Apr-2024")
Returns: NumberSince: Excel 2003