DAY()
Syntax. DAY(serial_number)
Definition. This function extracts the number of a day from a date. The DAY() function returns an integer from 1 through 31.
Arguments
serial_number (required). The date for which the day number is calculated
Background. With this function, as with the YEAR() and MONTH() functions, you can extract a valid date and use its components for other calculations. Use the DAY() function to extract the day from a date.
Problems might occur if you enter dates as text. The values returned by the functions YEAR(), MONTH(), and DAY() correspond to the Gregorian calendar.
See Also
For more information about saving dates in Excel, see the section titled The Excel Date System in Chapter 2.
Example. You may want to use the Excel AutoFilter ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
