Returns the numeric value of the day of the month for a specified date.

Syntax

DAY(<expD>)

<expD>

The date, or DateTime, whose corresponding day-of-the-month number you want to return.

Description

DAY( ) returns a day of the month number—a value from 1 to 31—for a specified date or DateTime .

DAY( ) returns zero for a blank date.