Skip to main content

DAY function

The DAY function is one of the date and time functions. It returns the day (a number from 1 to 31) of the date given in the numerical format (MM/dd/yyyy by default).

Syntax​

DAY(serial_number)

The DAY function has the following argument:

ArgumentDescription
serial_numberThe date of the day you want to find.

Notes​

How to apply the DAY function.

Examples​

The figure below displays the result returned by the DAY function.

DAY Function