DAY(date-code)

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