DAY

See also A-Z Spreadsheet Function List

Description Returns the day of the month that corresponds to the date represented by the supplied number.

Syntax DAY(serial_number)

serial_number is a date represented as a serial number or as text (e.g., “06-21-94” or “21-Jun-94”).

See Also HOUR , MINUTE , MONTH , NOW , SECOND , TODAY , WEEKDAY , and YEAR functions

Examples DAY(34399) returns 6

         DAY(“06-21-94”) returns 21