DAY (day of a date)

Navigation:  Formulas and functions > Functions from A to Z >

DAY (day of a date)

Previous pageReturn to chapter overviewNext page

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