DAY

From LongJump Support Wiki

The DAY function reads a date and returns the day value.

Syntax
DAY(dString)
Return
Number in the format: dd
Range 1 - 31


Example
DAY('09/21/2010') = 21