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).
DAY(serial_number)
The DAY function has the following argument:
How to apply the DAY function.
The figure below displays the result returned by the DAY function.