Documentation/How Tos/Calc: MONTH function

From Apache OpenOffice Wiki
Jump to: navigation, search



MONTH

Returns the month of a given date.

Syntax:

MONTH(date)

returns the month of date as a number, where January is 1 and December is 12.
date may be text or a date-time serial number.

Example:

MONTH("2008-06-04")

returns 6.

MONTH(A1)

where cell A1 contains the date 23Nov83 as a date-time serial number, returns 11.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_MONTH_function&oldid=243355"
Views
Personal tools
Navigation
Print/export
Tools