MONTH function
From Apache OpenOffice Wiki
<
Documentation
|
How Tos
Revision as of 13:44, 30 January 2024 by
DiGro
(
Talk
|
contribs
)
(
diff
)
← Older revision
| Latest revision (diff) | Newer revision → (diff)
Jump to:
navigation
,
search
CALC FUNCTIONS
Date & Time Functions
FUNCTIONS
TODAY
NOW
YEAR
MONTH
DAY
WEEKDAY
HOUR
MINUTE
SECOND
DATE
DATEVALUE
TIME
TIMEVALUE
EOMONTH
EDATE
WORKDAY
NETWORKDAYS
DAYS
DAYS360
DAYSINMONTH
DAYSINYEAR
WEEKS
WEEKSINYEAR
WEEKNUM
WEEKNUM_ADD
MONTHS
YEARS
ISLEAPYEAR
EASTERSUNDAY
YEARFRAC
< Previous Page
Next Page >
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
YEAR
DAY
WEEKDAY
HOUR
MINUTE
SECOND
Date & Time overview
Date & Time functions
Functions listed alphabetically
Functions listed by category
Category
:
Documentation/Reference/Calc/Date and Time functions
Views
Page
Discussion
View source
History
Personal tools
Log in
Navigation
Main Page
Recent changes
Download AOO
Documentation
User Forum
Extensions
Templates
Wiki Help
Search
Tools
What links here
Related changes
Special pages
Permanent link
Page information