Extracting Days from a Date (DAY)
Syntax: DAY(t)
The DAY function is used to convert a date given in any recognizable format into a day of the month. For example:
=DAY(40179)
returns 1 (January 1, 2010).
Figure 12-5. Sample result of the DAY function
You can give DAY the date in a more natural format:
=DAY("3/17/2010")
returns 17 (March 17, 2010).
See the description of the DATE function for another example of using the DAY function in practice.
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting 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.
