Syntax

DAY(when)

Description

DAY() gives the day of the month referenced by when.

when is a Text value interpreted as a Date.

Return Value

A Number value: the day of the month as a number (1 to 31) if found in when, or 0 if not found.

See Also

DATE(), MONTH(), TODAY(), WEEKDAY(), WEEKNUM(), YEAR()

Did this answer your question?