Excel DAY() function

Last update on August 19 2022 21:50:55 (UTC/GMT +8 hours)

DAY() function

The DAY() function is used to return the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.

Version : Excel 2013

Syntax

DAY(serial_number)

Parameters

Name	Description	Data Type	Required/ Optional
Serial_number	The date of the day you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions.	Number	Required

Remarks:

Microsoft Excel stores date as sequential serial numbers so they can be used in calculations. By default, January 1, 1900, is serial number 1, and January 1, 2010, is serial number 40179 because it is 40178 days after January 1, 1900.

The return value of YEAR, MONTH and DAY functions will be Gregorian values regardless of the display format for the supplied date value.If the display format of the supplied date is Hijri, the returned values for the YEAR, MONTH and DAY functions will be values associated with the equivalent Gregorian date.

Example:

Previous: Excel DATEVALUE() function
Next: Excel DAYS360() function