Syntax:
DAY(Date)
Description:
This returns the day of a date.
Example:
DAY("09/25/2018") returns 25
DAY("17th August") returns 17
If cell A1 contains the date value 9/25/2018: DAY(A1) returns 25
See also:
WEEKDAY, ISOWEEKNUM, ISOWEEEK, WEEKNUM, MONTH, YEAR