It returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.
The syntax of the function is the following:
DAY(serial_number)
serial_number: the serial number representation of a date
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the DAY function:
Use the appropriate function in the cell E11, to return the day of the date displayed in the cell E4.