The DAY function calculates the day of the month of the date-code you enter. For example, the formula
DAY(35649)
produces 8 as the day of the month, since the date code refers to 8th August 1997.
See also:
Other date functions