Difference between revisions of "Documentation/How Tos/Calc: MONTH function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
m |
||
Line 3: | Line 3: | ||
== MONTH == | == MONTH == | ||
Returns the month of a given date. | Returns the month of a given date. | ||
− | |||
=== Syntax: === | === Syntax: === | ||
Line 10: | Line 9: | ||
: <tt>'''date'''</tt> may be text or a date-time serial number. | : <tt>'''date'''</tt> may be text or a date-time serial number. | ||
− | |||
=== Example: === | === Example: === | ||
Line 18: | Line 16: | ||
<tt>'''MONTH(A1)'''</tt> | <tt>'''MONTH(A1)'''</tt> | ||
: where cell A1 contains the date <tt>'''23Nov83'''</tt> as a date-time serial number, returns <tt>'''11'''</tt>. | : where cell A1 contains the date <tt>'''23Nov83'''</tt> as a date-time serial number, returns <tt>'''11'''</tt>. | ||
− | |||
=== See also: === | === See also: === |
Revision as of 12:49, 18 January 2008
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("4Jun2008")
- returns 6.
MONTH(A1)
- where cell A1 contains the date 23Nov83 as a date-time serial number, returns 11.