Documentation/How Tos/Calc: DAYSINMONTH function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 15:00, 16 July 2008 by Drking (Talk | contribs)

Jump to: navigation, search


DAYSINMONTH

Returns the number of days in a month.

This function is only available if the Analysis AddIn is installed.

Syntax:

DAYSINMONTH(date)

returns the number of days in the month in which date lies.

Example:

DAYSINMONTH("2012-02-14")

returns 29, the number of days in February 2012 (2012 is a leap year).

See also:

EOMONTH, DAYSINYEAR, DAYS

Date & Time functions

Date & Time overview

Issues:

DAYSINMONTH is not part of the forthcoming ODFF international standard, and should not be regarded as portable. An alternative would be DAY(EOMONTH(date;0)).

Personal tools