DAY

Returns the day of the month corresponding to serial_number. The day is given as an integer ranging from 1 to 31.

Syntax

DAY(serial_number)

Serial_number   is the date-time code used by Microsoft Excel for date and time calculations. You can give serial_number as text, such as "4-15-93" or "15-Apr-1993", instead of as a number. The text is automatically converted to a serial number. For more information about serial_number, see NOW.

Remarks

Microsoft Excel for Windows and Microsoft Excel for the Macintosh use different date systems as their default. For more information, see NOW.

Examples

DAY("4-Jan") equals 4

DAY("15-Apr-1993") equals 15

DAY("8/11/93") equals 11