DAY

This function returns the day number of the month (integer 1 to 31) that corresponds to the specified date.

Syntax

DAY(date)

[Required] Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4).

DAY(A2)

DAY(R2C1)

DAY(366778) gives the result 14.

DAY(33239) gives the result 1 (because 33239 is the value for January 1, 1991).

DAY("7/4/2003 12:00")gives the result 4

DAY(DATE(2003,7,4))gives the result 4