DAY (day of a date)

<< Click to Display Table of Contents >>

DAY (day of a date)

Syntax:

DAY(Date)

Description:

Returns the day of a date.

Example:

DAY("09/25/2018") returns 25

DAY("17. 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