Return the day of the month for a given date (1-31).

DAY(Date)

Date: the date for which the day value is to be determined.

DAY(CALCDATE) will return the day of the month for the calculation date.

DAY(DATE(1,5,2017)) equals 5