DAY

Returns the day of the month

Usage examples 

• DAY("1/10/2010")

• DAY(tableA.fieldB)

Syntax 

DAY ( date_serial_num )

• date_serial_num - the date from which to extract the day. Must be a reference to a cell containing a date, a function returning a date type, or a number. Problems can occur if dates are entered as text

Returns 

number - the day of the date.

Functions reference